On 4/6/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> The problem seems to be that clan_members_v contains a call to an > expensive function: I'll bet that the function is marked VOLATILE. 8.2 is more conservative about optimizing away volatile functions than previous releases. If it has no side effects, mark it STABLE (or can it even be IMMUTABLE?).
That's exactly right, it should have been STABLE. Thanks a lot for figuring that out for me!