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(at)mailru(dot)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(at)enhanced(dot)com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah