Re: Allow use of stable functions with constraint exclusion - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Allow use of stable functions with constraint exclusion
Date
Msg-id 10628.1177974996@sss.pgh.pa.us
Whole thread Raw
In response to Allow use of stable functions with constraint exclusion  ("Marshall, Steve" <smarshall@wsi.com>)
Responses Re: Allow use of stable functions with constraint exclusion  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
"Marshall, Steve" <smarshall@wsi.com> writes:
> I have developed a small patch to optimizer/util/plancat.c that 
> eliminates one of hte caveats associated with constraint exclusions, 
> namely the inability to avoid searching tables based on the results of 
> stable functions.

Do you not understand why this is completely unsafe?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Heap page diagnostic functions
Next
From: "Henry B. Hotz"
Date:
Subject: Re: Fwd: [PATCHES] Preliminary GSSAPI Patches