Re: top-level DML under CTEs

2010/9/14 Merlin Moncure <mmoncure(at)gmail(dot)com>:
> On Mon, Sep 13, 2010 at 9:20 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> On Mon, Sep 13, 2010 at 9:15 AM, Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> wrote:
>>> The patch attached is based on the one rejected at the last CF for 9.0
>>> last year.
>>>
>>> http://archives.postgresql.org/message-id/16303.1266023203@sss.pgh.pa.us
>>>
>>> This patch implements the feature that allows top-level DMLs under CTE
>>> WITH clause. For example:
>>>
>>> WITH t AS (SELECT * FROM x)
>>> UPDATE y SET val = t.val FROM t
>>> WHERE y.key = t.key;
>>>
>>> This feature is part of writeable CTEs proposed by David Fetter originally.
>>
>> Thanks for pursuing this.  I think this will be a useful feature if we
>> can get it committed, and plus David Fetter will be very, very happy.
>> :-)
>
> Just to be clear, the attached patch is missing the part of the wCTE

Yes, the main part of wCTE that allows DMLs in WITH is still under
Marko Tikkaja. To work parallel, we split the tasks into pieces.

Regards,

--
Hitoshi Harada