Hello Tom,
thankyou for the reply but,
actually the number which are missing are in the range of 20-30 and at the
max only 3 transactions are going on at any given point in time.
So if 3 numbers are missing then it was understood the missing numbers are
very large.
Regards,
suvarna
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Suvarna" <suvarnat@cygnus.stpp.soft.net>
Cc: <pgsql-hackers@postgresql.org>
Sent: Tuesday, February 28, 2006 9:29 PM
Subject: Re: [HACKERS] bug in 7.3.2
> "Suvarna" <suvarnat@cygnus.stpp.soft.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