Re: getGeneratedKeys() - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: getGeneratedKeys()
Date
Msg-id 1112315611.30190.22.camel@jd2.commandprompt.com
Whole thread Raw
In response to getGeneratedKeys()  (Jamie Deppeler <jamie@doitonce.net.au>)
List pgsql-general
On Fri, 2005-04-01 at 10:05 +1000, Jamie Deppeler wrote:
> Hi to all,
>
> I have one problem with PostgreSQL and Java. I have a table with Primary
> key(serial) field, but after I insert a record i am unable to retrieve
> this value.  I have tried getGeneratedKeys() and i get nothing returned.

I am not a Java programmer but normally I would use select currval
('sequencename');


>
> There is another method to retrieve this field?
>
> thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
--
Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator - http://www.commandprompt.com/


pgsql-general by date:

Previous
From: Jamie Deppeler
Date:
Subject: getGeneratedKeys()
Next
From: Andrew Chambers
Date:
Subject: your thoughts on a crazy idea please