serial type; race conditions - Mailing list pgsql-sql

From jkakar@expressus.com
Subject serial type; race conditions
Date
Msg-id 20010326132728.A15965@expressus.com
Whole thread Raw
Responses Re: serial type; race conditions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Hi,

I'm using serial fields to generate IDs for almost all object in my
database.  I insert an empty row, get the CURRVAL() of the sequence
and then update to that value.

I had understood (and now, I can't find the reference to back this up)
that serial is implemented in such a way that race conditions between
DB connections can't happen.

Is this true?

Thanks,
Jamu.

-- 
Jamu Kakar (Developer)            Expressus Design Studio, Inc.
jkakar@expressus.com            708-1641 Lonsdale Avenue
V: (604) 903-6994            North Vancouver, BC, V7M 2J5


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Function Vanished
Next
From: Tom Lane
Date:
Subject: Re: Function Vanished