Re: Runtime pruning problem

On 2019-Jul-30, Tom Lane wrote:

> I wrote:
> > This may be arguing for a change in ruleutils' existing behavior,
> > not sure.  But when dealing with traditional-style inheritance,
> > I've always thought that Vars above the Append were referring to
> > the parent rel in its capacity as the parent, not in its capacity
> > as the first child.  With new-style partitioning drawing a clear
> > distinction between the parent and all its children, it's easier
> > to understand the difference.
> 
> OK, so experimenting, I see that it is a change: [...]

> The portion of this below the Append is fine, but I argue that
> the Vars above the Append should say "part", not "part_p1".
> In that way they'd look the same regardless of which partitions
> have been pruned or not.

So is anyone working on a patch to use this approach?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services