Re: sequences in transaction blocks

Okay, all clear.

Thanx a lot.

----- Original Message -----
From: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
To: "Marian Naghen" <naghen(at)ratb(dot)ro>
Cc: <pgsql-general(at)postgresql(dot)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
>