Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

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

In response to

pgsql-bugs by date

Next:From: raymondDate: 2005-04-01 10:33:49
Subject: windows installation
Previous:From: Rick RomanDate: 2005-03-31 19:18:19
Subject: sequences and rollback

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group