Re: BUG #2284: missing sequence number

From: Michael Fuhr <mike(at)fuhr(dot)org>
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:21:34
Message-ID: 20060227172133.GA56346@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Feb 27, 2006 at 11:52:19AM +0000, 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.

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

--
Michael Fuhr

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-02-27 17:24:19 Re: BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN
Previous Message Alvaro Herrera 2006-02-27 17:18:09 Re: BUG #2284: missing sequence number