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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Scott Chapman <scott_list(at)mischko(dot)com>
Cc: David Green <david(at)sagerobot(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SQL-question: returning the id of an insert querry
Date: 2003-11-10 21:46:11
Message-ID: 20031110214611.GA27541@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 10, 2003 at 08:56:03 -0800,
Scott Chapman <scott_list(at)mischko(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-11-10 21:51:53 Re: Temp rows - is it possible?
Previous Message Paul Thomas 2003-11-10 21:34:52 Re: SQL-question: returning the id of an insert querry