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
Hello Jonah,
No we are not caching the sequence
In the transaction for the first time we
use next val & then on we use curretn val.
Regards,
Suvarna
- Original Message -
From:
Jonah H.
Harris
To: Suvarna
Cc: pgsql-hackers@postgresql.org
Sent: Tue
we are using postgresql 7.3.2 version.
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 othercause then the
sequences tend to skip few numbers.After restarting the server the
nextval of sequence does
