Postgres Pro
Downloads
Home   >   mailing lists

Re: sequence rollback? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: sequence rollback?
Date
Msg-id 20051219052455.GA90243@winnie.fuhr.org
Whole thread Raw
In response to sequence rollback?  (stig erikson <stigerikson_nospam_@yahoo.se>)
List pgsql-general
Tree view 
On Sun, Dec 18, 2005 at 02:02:49PM +0100, stig erikson wrote:
> it seems like a sequence is always moving forward and cannot be rolled
> back. is this correct?

Yes.

> if it is correct, where in the docs do i find information about this
> behavior?

http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.4
http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html

--
Michael Fuhr

pgsql-general by date:

Previous
From: stig erikson
Date:
Subject: synchronization of news.postgresql.org and news.fr.postgresql.org
Next
From: Michael Fuhr
Date:
Subject: Re: One DB not backed up by pg_dumpall