Re: Problem with a rule on upgrade to v7.1.1 - Mailing list pgsql-hackers

From Jon Lapham
Subject Re: Problem with a rule on upgrade to v7.1.1
Date
Msg-id 20010511164658.A27970@cerberus.extracta.com.br
Whole thread Raw
In response to Re: Problem with a rule on upgrade to v7.1.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Problem with a rule on upgrade to v7.1.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom-

Thanks for the detective work.  This makes perfect sense now, and explains 
the radically different behaviour between 7.1RC1 and 7.1.1.  I will change 
my rules to not have to depend on Pg choosing which WHERE clause to 
evaluate first.

-Jon

PS: (Talking *way* above my head now) Would be possible to have 
EXPLAIN flag this type of problem?  Remember, the EXPLAIN output for 
7.1RC1 and 7.1.1 were identical.

-- 

-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---Jon LaphamExtracta Moléculas Naturais, Rio de
Janeiro,Brasilemail: lapham@extracta.com.br      web: http://www.extracta.com.br/
 
***-*--*----*-------*------------*--------------------*---------------


pgsql-hackers by date:

Previous
From: Dave Blasby
Date:
Subject: Rtree on custom data types; type conversion stops index use.
Next
From: Vince Vielhaber
Date:
Subject: Re: Search