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