Re: EXPLAIN doesn't show sufficient info for wCTE cases - Mailing list pgsql-hackers

From Tom Lane
Subject Re: EXPLAIN doesn't show sufficient info for wCTE cases
Date
Msg-id 28752.1298922868@sss.pgh.pa.us
Whole thread Raw
In response to Re: EXPLAIN doesn't show sufficient info for wCTE cases  (David Fetter <david@fetter.org>)
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> On Mon, Feb 28, 2011 at 11:44:06AM -0500, Robert Haas wrote:
>> I think it's good to include the table name, for sure.  I *think* I
>> agree that it isn't necessary to include the child names.

> Would this affect the use case of breaking up a too-long table into
> partitions?

> WITH f AS (
>     DELETE FROM ONLY foo
>     WHERE foo_ts >= '2011-01-01' AND foo_ts < '2011-02-01'
>     RETURNING *
> )
> INSERT INTO foo_201101
> SELECT * FROM f;

In that example, each ModifyTable node is constrained to a single
target table, so I'm not sure what your point is.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pl/python do not delete function arguments
Next
From: Simon Riggs
Date:
Subject: Re: Sync Rep v17