Message-ID: <419DBC5C.807@archonet.com>
Date: Fri, 19 Nov 2004 09:26:52 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 0.9 (X11/20041103)
MIME-Version: 1.0
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: Erik Thiele <erik@thiele-hydraulik.de>, pgsql-sql@postgresql.org
Subject: Re: get sequence value of insert command
References: <Pine.LNX.4.44.0411191136220.13400-100000@matrix.gatewaynet.com>
In-Reply-To: <Pine.LNX.4.44.0411191136220.13400-100000@matrix.gatewaynet.com>
Content-Type: text/plain; charset=ISO-8859-7; format=flowed
Content-Transfer-Encoding: 7bit

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