Re: [GENERAL] get the previous assigned sequence value

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] get the previous assigned sequence value
Дата
Msg-id 199912091823.NAA00275@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] get the previous assigned sequence value  (Ed Loehr <ELOEHR@austin.rr.com>)
Список 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 по дате отправления:

Предыдущее
От: Ed Loehr
Дата:
Сообщение: Re: [GENERAL] get the previous assigned sequence value
Следующее
От:
Дата:
Сообщение: Re: [GENERAL] get the previous assigned sequence value