Okay, all clear. Thanx a lot. ----- Original Message ----- From: "Tino Wildenhain" <tino@xxxxxxxxxxxxx> To: "Marian Naghen" <naghen@xxxxxxx> Cc: <pgsql-general@xxxxxxxxxxxxxx> Sent: Monday, December 19, 2005 7:50 AM Subject: Re: [GENERAL] sequences in transaction blocks > 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 >
