[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] 6.5.1 possibly lost rows
From:       James Thompson <jamest () math ! ksu ! edu>
Date:       1999-07-29 20:52:41
[Download RAW message or body]

On Thu, 29 Jul 1999, Brian Curnow wrote:
> 
> 1)  An INSERT statement that fails before completion can still use up a
> sequence #

I'm thinking this is what happened.  It seems to me postgresql would need
to read the sequence value generator before it could perform the insert.
Once a sequence generator is read it immediately increments. There is no
way to roll that back due to the fact that other processes could have read
the sequence generator after your process did and incremented it even
further.

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson    138 Cardwell Hall  Manhattan, Ks   66506    785-532-0561 
Kansas State University                          Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[prev in list] [next in list] [prev in thread] [next in thread]