Re: sequence rollback?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sequence rollback?
Date: 2005-12-19 05:24:55
Message-ID: 20051219052455.GA90243@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-12-19 05:48:40 Re: One DB not backed up by pg_dumpall
Previous Message Francisco Reyes 2005-12-19 04:29:13 One DB not backed up by pg_dumpall