Re: JDBC changes for 7.2... some questions...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC changes for 7.2... some questions...
Date: 2001-08-21 20:50:04
Message-ID: 10649.998427004@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com> writes:
> 1) Being able to use the RETURNING clause in prepared statements, like this
> "INSERT INTO tableName (key1,...)
> VALUES (value1,...)
> RETURNING primKeyName INTO ?"
> Which is what Oracle provides.

INSERT ... RETURNING was discussed recently, and I think people agreed
it's a good idea, but it got hung up on some unresolved issues about how
it should interact with ON INSERT rules for views. Search the pghackers
mailing list archives for details. At this point I think it's probably
too late to consider it for 7.2, but I'm still open to doing it in 7.3
if we can come up with a bulletproof spec.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-08-21 21:14:06 RE: Locale by default?
Previous Message Mikhail Terekhov 2001-08-21 20:31:45 Re: [HACKERS] Re: WIN32 errno patch

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruce Momjian 2001-08-21 20:54:17 Re: Couple of patches for jdbc driver
Previous Message Mihai Gheorghiu 2001-08-21 20:12:51 Data types