Re: Sequences in transaction

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