From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | jwieck(at)debis(dot)com |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] One more bugfix |
Date: | 1998-10-21 16:21:16 |
Message-ID: | 199810211621.MAA13239@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1998-10-21 16:32:42 | RE: [HACKERS] Anyone object to simplifying INSTALL instructions? |
Previous Message | Bruce Momjian | 1998-10-21 16:15:08 | Re: [HACKERS] New INET and CIDR types |