Re: Return the primary key of a newly inserted row?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Return the primary key of a newly inserted row?
Дата
Msg-id 20060626130028.GF24611@svana.org
обсуждение исходный текст
Ответ на Re: Return the primary key of a newly inserted row?  (Alban Hertroys <alban@magproductions.nl>)
Список pgsql-general
On Mon, Jun 26, 2006 at 11:31:32AM +0200, Alban Hertroys wrote:
> [1] Unless you manage to make it wrap around after 2^32 (or 2^64?) calls
> of nextval. But that's quite unlikely.

Even then, only if have wrapping enabled. With wrapping disabled,
nextval() will simply fail rather than return a value already returned.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: update impossible, constraint prevents it but it shouldn't
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unique attributes in profile management system