Re: [GENERAL] get the previous assigned sequence value
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Ed Loehr <ELOEHR@austin.rr.com>
Cc: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>, Dev Elop <dev@archonet.com>, pgsql-general@postgreSQL.org
Date: 1999-12-09T18:23:44Z
Lists: pgsql-general
> I think it is primarily because (a) it is intuitive to think there is a race > condition, which fortunately psgql folks have gone to significant efforts to > avoid, and (b) the documentation at > > http://www.postgresql.org/docs/postgres/sql-createsequence.htm > > is less than concise/clear on this issue. > > Same thing is true for the question of how to retrieve the newly-inserted > serial, which is why people keep asking the same question over and over (that, > and because people don't know about www.deja.com or the mailing list search > engine...or the engine is broken). My book will cover that in detail. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026