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
EnterpriseDB Corporation
732.331.1324