| From: | "Mark Hollomon" <mhh(at)nortelnetworks(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Re: postgres TODO |
| Date: | 2000-07-10 17:17:29 |
| Message-ID: | 396A0529.E94F09BC@americasm01.nt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-07-10 18:18:01 | Distribution making |
| Previous Message | Tom Lane | 2000-07-10 16:23:15 | Re: Templates |