Re: [GENERAL] get the previous assigned sequence value - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] get the previous assigned sequence value
Date
Msg-id 199912091823.NAA00275@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] get the previous assigned sequence value  (Ed Loehr <ELOEHR@austin.rr.com>)
List 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

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [GENERAL] get the previous assigned sequence value
Next
From:
Date:
Subject: Re: [GENERAL] get the previous assigned sequence value