Skip site navigation (1) Skip section navigation (2)

Re: bug in 7.3.2

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: Suvarna <suvarnat(at)cygnus(dot)stpp(dot)soft(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bug in 7.3.2
Date: 2006-02-28 15:26:05
Message-ID: 36e682920602280726n204f3e6frfa817c152c45dc80@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-02-28 15:26:31
Subject: Re: Dead Space Map
Previous:From: John DeSoiDate: 2006-02-28 15:14:51
Subject: Re: character encoding in StartupMessage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group