| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com> |
| Cc: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>, Dev Elop <dev(at)archonet(dot)com>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] get the previous assigned sequence value |
| Date: | 1999-12-09 18:23:44 |
| Message-ID: | 199912091823.NAA00275@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M.E. Versteeg | 1999-12-09 18:46:10 | How is the Query for 3 highest ranking values ? |
| Previous Message | Ed Loehr | 1999-12-09 17:57:32 | Re: [GENERAL] get the previous assigned sequence value |