Sequences, defaults and getting a new key

From: Jeff Willden <jeff(at)pavanell(dot)com>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Sequences, defaults and getting a new key
Date: 2008-02-22 04:28:13
Message-ID: 086B21D2-E8D2-402A-83E8-967EEF455879@pavanell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2008-02-22 05:16:44 Re: Sequences, defaults and getting a new key
Previous Message Greg Cocks 2008-02-20 17:37:42 Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP