Re: 8.4b1 regression? - Mailing list pgsql-hackers

From Eric B. Ridge
Subject Re: 8.4b1 regression?
Date
Msg-id 0D368A2B-FF07-4667-9FA3-1F358ED05A70@tcdi.com
Whole thread Raw
List pgsql-hackers
On Apr 20, 2009, at 2:27 PM, Eric B. Ridge wrote:

> Some investigation showed that the use of non-IMMUTABLE PL/PGSQL  
> functions as view columns, when these views are joined with other  
> views, cause the query to be planned poorly.

I'm sorry.  I should have said VOLATILE functions.  Which is the  
default if nothing is specified (and that's true for 8.1 and 8.4)

eric


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Patch for 8.5, transformationHook
Next
From: Robert Haas
Date:
Subject: Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE