Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group