Re: [GENERAL] sequences in transaction blocks

2005-12-19 Thread Marian Naghen
Okay, all clear. Thanx a lot. - Original Message - From: "Tino Wildenhain" <[EMAIL PROTECTED]> To: "Marian Naghen" <[EMAIL PROTECTED]> Cc: Sent: Monday, December 19, 2005 7:50 AM Subject: Re: [GENERAL] sequences in transaction blocks > Am Montag,

Re: [GENERAL] sequences in transaction blocks

2005-12-19 Thread Tino Wildenhain
Am Montag, den 19.12.2005, 09:39 + 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

Re: [GENERAL] sequences in transaction blocks

2005-12-18 Thread A. Kretschmer
am 19.12.2005, um 9:39:11 - mailte Marian Naghen folgendes: > 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. HTH, An

[GENERAL] sequences in transaction blocks

2005-12-18 Thread 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 ?     I use the following table:   CREATE TABLE proceduri(  procedura_id int4 NOT NUL