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

Re: bug in 7.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Suvarna" <suvarnat(at)cygnus(dot)stpp(dot)soft(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bug in 7.3.2
Date: 2006-02-28 15:59:46
Message-ID: 15375.1141142386@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"Suvarna" <suvarnat(at)cygnus(dot)stpp(dot)soft(dot)net> writes:
> We are facing a problem in nextval of sequence. The problem is as =
> follows,
> If the server shuts down abrupotly because of power failuar or any other
> cause then the sequences tend to skip few numbers.

This is not a bug, it is the designed behavior.  It's not really
different from the case of a number going unused because a transaction
does nextval() and then rolls back --- you cannot assume that the
sequence of used values has no holes, in any case.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2006-02-28 16:10:05
Subject: Re: Dead Space Map
Previous:From: Albe LaurenzDate: 2006-02-28 15:55:26
Subject: Re: new feature: LDAP database name resolution

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