| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Ashley Cambrell <ash(at)freaky-namuh(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Roadmap for FE/BE protocol redesign |
| Date: | 2003-03-10 22:06:00 |
| Message-ID: | 20429.1047333960@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
Neil Conway <neilc(at)samurai(dot)com> writes:
> On Mon, 2003-03-10 at 16:37, Ashley Cambrell wrote:
>> This would also get around the problem of getting values from newly
>> inserted rows (eg PKs) without resorting to OIDs.
> That's not a problem: ensure that the newly inserted row has a SERIAL
> column, and use currval().
There was some talk awhile back of inventing INSERT ... RETURNING and
UPDATE ... RETURNING commands so that you could pass back computed
values to the frontend without an extra query. It doesn't seem to have
gotten further than a TODO item yet, though. AFAICS this does not need
a protocol extension, anyway --- it'd look just the same as a SELECT
at the protocol level.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashley Cambrell | 2003-03-10 22:07:03 | Re: Roadmap for FE/BE protocol redesign |
| Previous Message | Neil Conway | 2003-03-10 21:59:12 | Re: Roadmap for FE/BE protocol redesign |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashley Cambrell | 2003-03-10 22:07:03 | Re: Roadmap for FE/BE protocol redesign |
| Previous Message | Neil Conway | 2003-03-10 21:59:12 | Re: Roadmap for FE/BE protocol redesign |