On 4/6/07, Tom Lane <[EMAIL PROTECTED]> 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!
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
