Re: sequences and rollback

On Thu, Mar 31, 2005 at 11:18:19AM -0800, Rick Roman wrote:
>
> Do I understand correctly that you cannot roll back sequences?

Correct.  This is mentioned in the documentation and in the FAQ.

http://www.postgresql.org/docs/8.0/interactive/functions-sequence.html
http://www.postgresql.org/docs/faqs.FAQ.html#4.11.4

You can manually set a sequence's value with setval() or ALTER
SEQUENCE, but that's not the same as rolling back values that you
didn't use.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/