Re: Sequences in transaction - Mailing list pgsql-general

From Camm Maguire
Subject Re: Sequences in transaction
Date
Msg-id 54puj7re2j.fsf@intech19.enhanced.com
Whole thread Raw
In response to views/stored procedures  (Jeff Davis <jdavis@wasabimg.com>)
Responses Re: Sequences in transaction  (Mike Castle <dalgoda@ix.netcom.com>)
List pgsql-general
Greetings!  I've run into this too, and it appears to me not to roll
back either.  A pity, as it forced us to make a separate table to hold
the last sequence value and update the table in a trigger.

Take care,

igor <igor_kh@mailru.com> writes:

> Hi,
>
> Help me please to understand such a thing:
> Rollback of sequences doesn't work in transaction.
> Is it right? Or may be there is another way to restore
> it's value?
> Running PG 7.02 on RH 6.0
>
> Thanks ,
> Igor.
>
>
>
>

--
Camm Maguire                             camm@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens."  --  Baha'u'llah

pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Re: Where do COMMENTs on columns go?
Next
From: Dan Lyke
Date:
Subject: Why PostgreSQL is not that popular as MySQL?