Re: Return the primary key of a newly inserted row? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Return the primary key of a newly inserted row?
Date
Msg-id 20060626130028.GF24611@svana.org
Whole thread Raw
In response to Re: Return the primary key of a newly inserted row?  (Alban Hertroys <alban@magproductions.nl>)
List 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.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: update impossible, constraint prevents it but it shouldn't
Next
From: Tom Lane
Date:
Subject: Re: unique attributes in profile management system