Re: leaky views, yet again - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: leaky views, yet again
Date
Msg-id 4C4487C8.1040805@enterprisedb.com
Whole thread Raw
In response to Re: leaky views, yet again  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
Responses Re: leaky views, yet again
List pgsql-hackers
On 09/07/10 06:47, KaiGai Kohei wrote:
> When leaky and non-leaky functions are chained within a WHERE clause,
> it will be ordered by the cost of functions. So, we have possibility
> that leaky functions are executed earlier than non-leaky functions.

No, that needs to be forbidden as part of the fix. Leaky functions must
not be executed before all the quals from the view are evaluated.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: leaky views, yet again
Next
From: Heikki Linnakangas
Date:
Subject: Re: leaky views, yet again