| From: | James Thompson <jamest(at)math(dot)ksu(dot)edu> |
|---|---|
| To: | Brian Curnow <bcurnow(at)sonnet(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] 6.5.1 possibly lost rows |
| Date: | 1999-07-29 20:52:41 |
| Message-ID: | Pine.LNX.4.10.9907291546290.3417-100000@hobbes.math.ksu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David HM Spector | 1999-07-29 22:49:47 | PG95 module for Apache1.3.x..? |
| Previous Message | Brian Curnow | 1999-07-29 20:21:00 | 6.5.1 possibly lost rows |