Message-ID: <40CFECF5.6060203@interzone.gr>
Date: Wed, 16 Jun 2004 09:47:17 +0300
From: Michalis Kabrianis <mk@interzone.gr>
Organization: Interzone
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7b) Gecko/20040421
MIME-Version: 1.0
To: Andrei Bintintan <klodoma@ar-sd.net>
Cc: 'mixo' <mixo@coza.net.za>, pgsql-sql@postgresql.org
Subject: Re: Last insert id
References: <20040615070408.80EA4175A8@ar-sd.net>
In-Reply-To: <20040615070408.80EA4175A8@ar-sd.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


Andrei Bintintan wrote:
> "Is it safe to use "select max(table1_id) from table1" after the insert?"
> 
> Yes it is safe, but ONLY if you use it inside a transaction.(BEGIN/COMMIT).
> 
> BR.
> 

Hi,
I think it would be safe to use :
select currval('tablename_idname_seq');
inside a session to receive the current value of the sequence that feeds 
the serial column (i.e. the last inserted value on that session). Every 
other session is irrelevant (as the currval returns the session-specific 
value).
If I understand correctly, it doesn't even need the transaction to be 
open (in which case all consecutive inserts on the same table would block).

M.K.
> 
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
> On Behalf Of mixo
> Sent: Wednesday, June 09, 2004 9:24 AM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] Last insert id
> 
> I have three tables which are related a serial field, table1_id, in on of
> the tables. Updating the tables is done through a transaction. My problem
> is, once I have insert  a row in the first tables with table1_id, I need for
> the other two tables. How can I get this? Is it safe to use "select
> max(table1_id) from table1" after the insert?
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html