On Jun 1, 2007, at 15:00 , Tom Lane wrote:
Michael Glaesemann <[EMAIL PROTECTED]> writes:
On May 31, 2007, at 11:46 , [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
