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

From Alvaro Herrera
Subject Re: BUG #2284: missing sequence number
Date
Msg-id 20060227171809.GE6490@surnet.cl
Whole thread Raw
In response to BUG #2284: missing sequence number  ("" <suvarnat@cygnus.stpp.soft.net>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: "Nicholas Vinen"
Date:
Subject: BUG #2285: Can not access database after successful PITR - file naming problems
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #2284: missing sequence number