Re: sequences and rollback

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Rick Roman <rick(at)cotse(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: sequences and rollback
Date: 2005-03-31 19:32:41
Message-ID: 20050331193241.GA50337@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message raymond 2005-04-01 10:33:49 windows installation
Previous Message Rick Roman 2005-03-31 19:18:19 sequences and rollback