Re: [INTERFACES] ecpg and getting just assigned serial number - Mailing list pgsql-interfaces

From Bryan White
Subject Re: [INTERFACES] ecpg and getting just assigned serial number
Date
Msg-id 000f01befde8$6ec81940$22d260d1@arcamax.com
Whole thread Raw
In response to Re: [INTERFACES] ecpg and getting just assigned serial number  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
> theofilu@eunet.at (Theofilu Andreas) writes:
> > to Informix's 'esqlc'. However. I have a table with a field of type
> > 'serial'. Now I've no problem to insert any sentences into this table,
but
> > immediately after inserting a new sentence I need the newly assigned
number
> > to the serial field in the table. How can I access this number?
>
> Postgres doesn't return that number automatically; you'll have to run a
> separate query to find out what was inserted.  You could do something
> like
> select serialcolumn from table where oid = NNNN;
> since a single-row insert does return the OID of the inserted row.
> (Note this will be pretty slow if the table is big and does not have
> an index on OID.)
>
> Another possibility is to execute nextval() for yourself and then insert
> that result explicitly when you create the row.  Still takes two queries,
> though.

Another possibility is to "select currval('seqname')" where seqname is the
name of the sequence associated with the serial field.  currval's are
maintained per connection so there are no multiuser problems.  In many cases
you don't have retrieve the value but just use the expression is subsequent
statements.




pgsql-interfaces by date:

Previous
From: "Ansley, Michael"
Date:
Subject: RE: [INTERFACES] ecpg and getting just assigned serial number
Next
From: Roberto Joao Lopes Garcia
Date:
Subject: Re: [INTERFACES] Can PostgreSQL be used in a C++ application