Are you caching sequences?
On 2/28/06, Suvarna <suvarnat(at)cygnus(dot)stpp(dot)soft(dot)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
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-02-28 15:26:31|
|Subject: Re: Dead Space Map |
|Previous:||From: John DeSoi||Date: 2006-02-28 15:14:51|
|Subject: Re: character encoding in StartupMessage |