Re: BUG #2284: missing sequence number

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: suvarnat(at)cygnus(dot)stpp(dot)soft(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2284: missing sequence number
Date: 2006-02-27 17:18:09
Message-ID: 20060227171809.GE6490@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

suvarnat(at)cygnus(dot)stpp(dot)soft(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2006-02-27 17:21:34 Re: BUG #2284: missing sequence number
Previous Message David Sauer 2006-02-27 14:39:37 BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN