Postgres Pro
Downloads
Home   >   mailing lists

Re: sequences in transaction blocks - Mailing list pgsql-general

From A. Kretschmer
Subject Re: sequences in transaction blocks
Date
Msg-id 20051219074225.GB29953@webserv.wug-glas.de
Whole thread Raw
In response to sequences in transaction blocks  ("Marian Naghen" <naghen@ratb.ro>)
List pgsql-general
Tree view 
am  19.12.2005, um  9:39:11 -0000 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, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: "Marian Naghen"
Date:
Subject: sequences in transaction blocks
Next
From: Tino Wildenhain
Date:
Subject: Re: sequences in transaction blocks