Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group