Applied.
> Hope this is the last one,
>
> Bruce, please apply.
>
> The patch does 2 things:
>
> Fixes a bug in the rule system that caused a crashing
> backend when a join-view with calculated column is used
> in subselect.
>
> Modifies EXPLAIN to explain rewritten queries instead of
> the plain SeqScan on a view. Rules can produce very deep
> nested plans, so I lowered the indentation a little.
>
> The patch is regression tested. Now the rule system handles
> this:
>
> DELETE FROM shoelace WHERE EXISTS
> (SELECT * FROM shoelace_candelete
> WHERE sl_name = shoelace.sl_name);
>
> Doesn't look that complicated. But:
>
> View shoelace is a join of 2 tables with a calculated column.
>
> View shoelace_candelete is a qualified select from
> shoelace_obsolete.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026