Re: collision in serial numbers after INSERT?

On Jun 1, 2007, at 15:00 , Tom Lane wrote:

> Michael Glaesemann <grzm@seespotcode.net> writes:
>> On May 31, 2007, at 11:46 , lawpoop@gmail.com wrote:
>>> However, I wondered, if I were in an environment where there were
>>> many
>>> concurrent inserts, would it be possible that I didn't get the
>>> serial
>>> number of the insert that *I* just did?
>
>> No.
>
> Uh, yes, because he was using "SELECT last_value FROM seq" which is
> indeed subject to race conditions.  currval() would be far safer.

I read that much too quickly. My apologies, lawpoop. And thanks, Tom.

Michael Glaesemann
grzm seespotcode net