Thread: BUG #2284: missing sequence number

BUG #2284: missing sequence number

From
""
Date:
The following bug has been logged online:

Bug reference:      2284
Logged by:
Email address:      suvarnat@cygnus.stpp.soft.net
PostgreSQL version: 7.3.2
Operating system:   linux
Description:        missing sequence number
Details:

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.

Re: BUG #2284: missing sequence number

From
Alvaro Herrera
Date:
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.

This is per design, i.e. not a bug.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Re: BUG #2284: missing sequence number

From
Michael Fuhr
Date:
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