Re: PostgreSQL roadmap for 8.2 and beyond. - Mailing list pgsql-hackers

From Kevin McArthur
Subject Re: PostgreSQL roadmap for 8.2 and beyond.
Date
Msg-id 004c01c5d332$ce2c9160$0701a8c0@kdesktop
Whole thread Raw
In response to Re: PostgreSQL roadmap for 8.2 and beyond.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
I've not actually looked in the source but i presume that insert returning 
would work internally similar to a select in an update_after or insert_after 
trigger.
If so then it should not care that an entry is a sequence or otherwise, it 
should care what the actual data in the table is. It must work on the actual 
data to properly work with defaults that are a product of a function that is 
not a serial. Eg a uniqueidentifier's newid() func.

I could be wrong. But insert returning without picking up column defaults 
would be extremely useless. getAutoGeneratedKeys in jdbc seems like it would 
be a very useful interface, so if  this patch doesnt support implementing 
this, someone should fix that. (I'd check/fix it myself, but i don't have 
much of a clue when it comes to c programming)

Kevin McArthur
----- Original Message ----- 
From: "Dave Cramer" <pg@fastcrypt.com>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: "Neil Conway" <neilc@samurai.com>; "PostgreSQL-development" 
<pgsql-hackers@postgresql.org>
Sent: Monday, October 17, 2005 6:12 AM
Subject: Re: [HACKERS] PostgreSQL roadmap for 8.2 and beyond.


>I fail to see how this solves the problem of getting auto generated  keys.
>
> 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
>
> if we had that then we could correctly implement getAutoGeneratedKeys  for 
> jdbc.
>
> Dave
> On 17-Oct-05, at 8:33 AM, Bruce Momjian wrote:
>
>> Neil Conway wrote:
>>
>>> On Sun, 2005-16-10 at 01:20 -0700, Kevin McArthur wrote:
>>>
>>>> Don't forget insert/update returning.
>>>>
>>>
>>> Omar Kilani has a patch for this:
>>>
>>> http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php
>>>
>>> I would like to see it get into 8.2
>>>
>>
>> Yes, this is in the 8.2 patches queue:
>>
>>     http://momjian.postgresql.org/cgi-bin/pgpatches_hold
>>
>>
>> -- 
>>   Bruce Momjian                        |  http://candle.pha.pa.us
>>   pgman@candle.pha.pa.us               |  (610) 359-1001
>>   +  If your life is a hard drive,     |  13 Roberts Road
>>   +  Christ can be your backup.        |  Newtown Square,  Pennsylvania 
>> 19073
>>
>> ---------------------------(end of  broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
> 



pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: More problems with the win32 installer for 8.1 beta3
Next
From: Martijn van Oosterhout
Date:
Subject: Re: PostgreSQL roadmap for 8.2 and beyond.