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
<[EMAIL PROTECTED]>
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
|
- Re: [HACKERS] bug in 7.3.2 Suvarna
-