Re: sequences in transaction blocks

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: sequences in transaction blocks
Date: 2005-12-19 07:42:25
Message-ID: 20051219074225.GB29953@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ===

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-12-19 07:50:48 Re: sequences in transaction blocks
Previous Message Michael Fuhr 2005-12-19 06:01:22 Re: Select list of table names for particular DB