Re: [HACKERS] One more bugfix

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026