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@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