Re: SQL-question: returning the id of an insert querry

Bruno Wolff III <bruno@wolff.to>

From: Bruno Wolff III <bruno@wolff.to>
To: Scott Chapman <scott_list@mischko.com>
Cc: David Green <david@sagerobot.com>, pgsql-general@postgresql.org
Date: 2003-11-10T21:46:11Z
Lists: pgsql-general
On Mon, Nov 10, 2003 at 08:56:03 -0800,
  Scott Chapman <scott_list@mischko.com> wrote:
> 
> Thanks for the clarification.  With web applications and connection 
> pooling, it would appear that it's quite easy to get incorrect values 
> back.  This is what I thought. 

Not normally. Normally both queries are going to be done in one web
request and it would be very unusual to be using a system where
anyone else could use the same connection for a query in between.