Re: Insert race hazard condition.

On Tue, Mar 25, 2003 at 13:01:17 -0700, Roy Souther <roy@SiliconTao.com> wrote:
> First of all I am a programmer not an DBA expert. 
> 
> For a long time now when I create a table I have an index field that is
> of type int4 to be the primary key. All of the queries and activity on
> each record uses this field to do the posting, manipulating and reading
> of data to and from tables.

[snip]

> Is there a better way to do this? How do DBAs with a lot of connections
> safely create new records?

The short answer is to use sequences. Use currval to get the value assigned
earlier in the same transaction.