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

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: (view raw, whole thread or download thread mbox)
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                      
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-bugs by date

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

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