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" <[EMAIL PROTECTED]> To: "Suvarna" <[EMAIL PROTECTED]> Cc: <pgsql-hackers@postgresql.org> Sent: Tuesday, February 28, 2006 9:29 PM Subject: Re: [HACKERS] bug in 7.3.2 > "Suvarna" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
