Re: Using results from INSERT ... RETURNING - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Using results from INSERT ... RETURNING
Date
Msg-id 9418.1254671239@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using results from INSERT ... RETURNING  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Using results from INSERT ... RETURNING
Re: Using results from INSERT ... RETURNING
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> Well, I think a patch to implement writeable CTEs is probably going to
> have to handle this case - I don't think we can just ignore rewrite
> rules when processing a CTE.  But it does seem to be beyond the scope
> of the current patch.

I hadn't been paying too much attention to this thread, but ... why
is anyone worrying about that?  Rewrite rules are not the concern
of either the planner or the executor.  A "do also" rule will result
in two entirely separate Query trees, which will each be planned
separately and executed separately.  Any given executor run only
has to think about one type of DML command --- otherwise the executor
would be broken already, since it takes only one command-type argument.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: taking a stab at agg(foo ORDER BY bar)
Next
From: Marko Tiikkaja
Date:
Subject: Re: Using results from INSERT ... RETURNING