Re: [HACKERS] top-level DML under CTEs

Поиск
Список
Период
Сортировка
От Hitoshi Harada
Тема Re: [HACKERS] top-level DML under CTEs
Дата
Msg-id AANLkTimG=XftAG_WV8SuT9YNJQHmzFAys0ZyYm5we9CR@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] top-level DML under CTEs  (Hitoshi Harada <umi.tanuki@gmail.com>)
Ответы Re: [HACKERS] top-level DML under CTEs  ("Erik Rijkers" <er@xs4all.nl>)
Список 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

Вложения

В списке pgsql-rrreviewers по дате отправления:

Предыдущее
От: ๏̯͡๏ Guido Barosio
Дата:
Сообщение: Re: Patch reviewers
Следующее
От: "Erik Rijkers"
Дата:
Сообщение: Re: [HACKERS] top-level DML under CTEs