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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
