Okay, all clear. Thanx a lot.
----- Original Message ----- From: "Tino Wildenhain" <[EMAIL PROTECTED]> To: "Marian Naghen" <[EMAIL PROTECTED]> Cc: <pgsql-general@postgresql.org> 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 > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
