Re: bug in 7.3.2
Jonah H. Harris <jonah.harris@gmail.com>
From: "Jonah H. Harris" <jonah.harris@gmail.com>
To: Suvarna <suvarnat@cygnus.stpp.soft.net>
Cc: pgsql-hackers@postgresql.org
Date: 2006-02-28T15:26:05Z
Lists: pgsql-hackers
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