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 -----
Sent: Tuesday, February 28, 2006 8:56 PM
Subject: Re: [HACKERS] bug in 7.3.2
Are you caching sequences?
On 2/28/06, Suvarna <suvarnat@cygnus.stpp.soft.net> wrote: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 other
cause then the sequences tend to skip few numbers.
After restarting the server the nextval of sequence doest match
with the last number.
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324