Am Montag, den 19.12.2005, 09:39 +0000 schrieb Marian Naghen:
> I want to insert records inside a transaction block (BEGIN -
> COMMIT/ROLLBACK). If the transaction fails,
> the sequence do not rollback and retain the new value.
>
> This is the default behavior of sequences ?
Yes it is (its the whole point of sequences)
please see the docs, for example:
http://www.postgresql.org/docs/current/static/functions-sequence.html
especially the last paragraph.
HTH
Tino Wildenhain