Thread: BUG #2284: missing sequence number

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.

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.

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