| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL roadmap for 8.2 and beyond. |
| Date: | 2005-10-17 16:43:47 |
| Message-ID: | 9558.1129567427@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> On Mon, Oct 17, 2005 at 09:12:35AM -0400, Dave Cramer wrote:
>> AFAIKS, the protocol needs to be tweaked to return at a minimum the
>> currval for the first serial in the row, but more correctly all of
>> the modified currval's for an insert
> In what sense? It seems to do exactly what you want. The example in the
> documentation is:
> INSERT INTO films (title) VALUES ('Yojimbo') RETURNING film_id;
What Dave wants is for INSERT to automagically return any autogenerated
keys, *without* any explicit RETURNING clause.
I don't think that's a reasonable request, however: it amounts to a
request to break the protocol and impose possibly-useless overhead on
everyone's inserts, in order to save the JDBC driver some work in
analyzing table metadata.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-10-17 16:44:44 | Re: libpq's pollution of application namespace |
| Previous Message | Tony Caduto | 2005-10-17 16:43:25 | Re: More problems with the win32 installer for 8.1 beta3 |