Sequences, defaults and getting a new key - Mailing list pgsql-novice

From Jeff Willden
Subject Sequences, defaults and getting a new key
Date
Msg-id 086B21D2-E8D2-402A-83E8-967EEF455879@pavanell.com
Whole thread Raw
Responses Re: Sequences, defaults and getting a new key
Re: Sequences, defaults and getting a new key
List pgsql-novice
When the primary key of a table defaults to the nextval() of a
sequence, if you insert a new record into the table and accept the
default, how do you then select the value that was just used as the
new primary key and guarantee that you don't accidentally get the
value that another user just generated at about the same instant?

Thanks,

Jeff Willden

pgsql-novice by date:

Previous
From: "Greg Cocks"
Date:
Subject: Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP
Next
From: Tom Lane
Date:
Subject: Re: Sequences, defaults and getting a new key