Re: get sequence value of insert command - Mailing list pgsql-sql

From Richard Huxton
Subject Re: get sequence value of insert command
Date
Msg-id 419DBC5C.807@archonet.com
Whole thread Raw
In response to Re: get sequence value of insert command  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
Achilleus Mantzios wrote:
>>
>>now how do i know the id of my newly inserted element? and
>>how can this be done in a completely concurrency safe way?
> 
> 
> The way to do this is by reading the docs :)
> 
> use currval, it is session safe.

The increase in this question suggests the number of new users has 
increased since 8.0 went into beta-test. It's pretty much the first 
question anyone asks.

I seem to recall it was mine. I made the mistake of assuming it wasn't 
concurrency safe and was gently corrected by one of the community. I 
think it might have been a Tim/Tam Lane. Wonder what happened to him? :-)

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: get sequence value of insert command
Next
From: "Iain"
Date:
Subject: Re: get sequence value of insert command