sequences and Transactions

From: Elmar(dot)Haneke(at)gmx(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: sequences and Transactions
Date: 2000-04-27 08:38:55
Message-ID: 5FB7AC378C@haneke.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Inoue 2000-04-27 08:48:24 RE: Revisited: Transactions, insert unique.
Previous Message Andras Balogh 2000-04-27 08:03:13 Re: pgsql DATE