"Suvarna" <suvarnat(at)cygnus(dot)stpp(dot)soft(dot)net> writes:
> We are facing a problem in nextval of sequence. The problem is as =
> 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
pgsql-hackers by date
|Next:||From: Hannu Krosing||Date: 2006-02-28 16:10:05|
|Subject: Re: Dead Space Map|
|Previous:||From: Albe Laurenz||Date: 2006-02-28 15:55:26|
|Subject: Re: new feature: LDAP database name resolution |