sequences and Transactions - Mailing list pgsql-general

From Elmar.Haneke@gmx.de
Subject sequences and Transactions
Date
Msg-id 5FB7AC378C@haneke.de
Whole thread Raw
Responses Re: sequences and Transactions
List pgsql-general
Hi!

how can I setup sequences to have the current-value reset in case
of an Transaction rollback.

My intension is to get an contignous numbering of the rows.
Currently in case of an Rollback one number is skipped since
the record itself is not inserted but the counter is not reset.

Elmar

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: I'm just doin' the 7.0 RC1 install and have some input on the documentation.
Next
From: Peter Eisentraut
Date:
Subject: RE: Revisited: Transactions, insert unique.