Horton

Re: Re: postgres TODO

Mark Hollomon <mhh@nortelnetworks.com>

View thread
From: "Mark Hollomon" <mhh@nortelnetworks.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2000-07-10T17:17:29Z
Lists: pgsql-hackers 
Tom Lane wrote:
> it.  We already return the OID which is sufficient info to select the
> row again if you need it.  Returning the primary key would be
> considerably more work for no visible gain in functionality...

But OID is not available for views. I have already run into
this situation. I have a view which is a join across 3 tables.
two of the underlying tables have serial fields as primary keys.

INSERT ... RETURNING ... would be very nice indeed.

-- 

Mark Hollomon
mhh@nortelnetworks.com
ESN 451-9008 (302)454-9008