Re: [HACKERS] top-level DML under CTEs - Mailing list pgsql-rrreviewers

From Hitoshi Harada
Subject Re: [HACKERS] top-level DML under CTEs
Date
Msg-id AANLkTimG=XftAG_WV8SuT9YNJQHmzFAys0ZyYm5we9CR@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] top-level DML under CTEs  (Hitoshi Harada <umi.tanuki@gmail.com>)
Responses Re: [HACKERS] top-level DML under CTEs  ("Erik Rijkers" <er@xs4all.nl>)
List pgsql-rrreviewers
2010/10/1 Hitoshi Harada <umi.tanuki@gmail.com>:
> 2010/9/30 Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>:
>> On 2010-09-23 9:12 AM +0300, Hitoshi Harada wrote:
>>>
>>> Since the transformation of
>>> WITH clause to cheat postgres is in the parser stage currently, I
>>> wonder if this should be done in the rewriter or the planner stage.
>>
>> It's been about a week now.  Should we expect a new patch soon?
>>
>>
>
> Yep, I'm working it now. You'll see the conclusion in a day or so.

...and attached is the latest patch. It contains LIMIT etc. bug of
INSERT fixes and I confirmed the barrule case correctly in this
version.

> =# CREATE RULE barrule AS ON UPDATE TO bar DO INSTEAD
> -# WITH RECURSIVE t AS (SELECT -1)
> -# INSERT INTO bar
> -# WITH t AS (SELECT 1)
> -# VALUES((SELECT * FROM t));

Regards,


--
Hitoshi Harada

Attachment

pgsql-rrreviewers by date:

Previous
From: ๏̯͡๏ Guido Barosio
Date:
Subject: Re: Patch reviewers
Next
From: "Erik Rijkers"
Date:
Subject: Re: [HACKERS] top-level DML under CTEs