Re: INSERT and get ID

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Peter(dot)Zoche(at)materna(dot)de
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: INSERT and get ID
Date: 2005-07-27 13:37:52
Message-ID: 753B003A-F850-4450-A116-88E6BC353BA3@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Yes, it's absolutely safe!

Dave
On 27-Jul-05, at 9:29 AM, Peter(dot)Zoche(at)materna(dot)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
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Csaba Nagy 2005-07-27 13:40:32 Re: INSERT and get ID
Previous Message Peter.Zoche 2005-07-27 13:29:41 Re: INSERT and get ID