Re: bug in 7.3.2

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 ----- 
  From: Jonah H. Harris 
  To: Suvarna 
  Cc: pgsql-hackers@postgresql.org 
  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 <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