From: | Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: top-level DML under CTEs |
Date: | 2010-09-14 00:44:46 |
Message-ID: | AANLkTimCwcMnhe_77uAK4-5kuS24xG3xmJuMi2OAtS6U@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-rrreviewers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2010-09-14 00:55:21 | Re: pg_ctl emits strange warning message |
Previous Message | Fujii Masao | 2010-09-14 00:39:13 | Re: pg_ctl emits strange warning message |
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Tiikkaja | 2010-09-14 15:50:31 | Re: top-level DML under CTEs |
Previous Message | Robert Haas | 2010-09-13 19:14:49 | Re: top-level DML under CTEs |