2010/10/1 Hitoshi Harada <umi.tan...@gmail.com>: > 2010/9/30 Marko Tiikkaja <marko.tiikk...@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
toplevel-dml-cte.20101003.diff
Description: Binary data
-- Sent via pgsql-rrreviewers mailing list (pgsql-rrreview...@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-rrreviewers
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
