Re: INSERT and get ID - Mailing list pgsql-jdbc

From Csaba Nagy
Subject Re: INSERT and get ID
Date
Msg-id 1122471632.2837.79.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: INSERT and get ID  (Peter.Zoche@materna.de)
List pgsql-jdbc
It will be perfectly safe, as curval will return you the last value
created in the current session. So you can be sure it's your value
unless you use the same connection concurrently in different threads,
but in that case you would have bigger problems :-)

Cheers,
Csaba.

On Wed, 2005-07-27 at 15:29, Peter.Zoche@materna.de wrote:
> > You have to do a a "SELECT curval('myseq')" after the insert.
>
> I had this in mind, too, but I am not sure if it is really safe if
> there are several inserts at the same time...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend


pgsql-jdbc by date:

Previous
From: Peter.Zoche@materna.de
Date:
Subject: Re: INSERT and get ID
Next
From: Dave Cramer
Date:
Subject: Re: INSERT and get ID