Re: BUG #2284: missing sequence number - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #2284: missing sequence number
Date
Msg-id 20060227172133.GA56346@winnie.fuhr.org
Whole thread Raw
In response to BUG #2284: missing sequence number  ("" <suvarnat@cygnus.stpp.soft.net>)
List pgsql-bugs
On Mon, Feb 27, 2006 at 11:52:19AM +0000, suvarnat@cygnus.stpp.soft.net wrote:
> if the server shuts down abrupotly because of power failuar or any other
> cause then the sequences tend to skip few numbers.
> After restarting the postgresql server the nextval of sequence doest match
> with the last number.

http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.4

--
Michael Fuhr

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #2284: missing sequence number
Next
From: Tom Lane
Date:
Subject: Re: BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN