Re: Last Insert

On 3/13/02 10:58 AM, "Stephan Szabo"  wrote:

> On Wed, 13 Mar 2002, Marcelo Pereira wrote:
> 
>> Hello All,
>> 
>> I have two tables, the first is parental and the second is a child of the
>> first.
>> 
>> Ex.:
>> 
>> create table first (id SERIAL, descrip CHAR(20));
>> create table second (id INTEGER references first(id), state CHAR(2));
>> 
>> I have `all' the values to make the inserts in the two tables (ie, descrip
>> and state), so I `would' use:
>> 
>> INSERT into first (descrip) values ($descr);
>> INSERT into second (id,state) values (?????????,$state);
> 
> currval('first_id_seq') should get you the last sequence value given to
> your session.


I havw a question. Is this reliable even in a connection-pooled environment?
I've always been a little scared of any possible concurrency issues here so
I usually look at the result of the INSERT to get the oid, then use the oid
to query for my key. Am I being too cautious?

-- steve