han(dot)holl(at)informationslogik(dot)nl writes:
> On Thursday 20 October 2005 23:48, Tom Lane wrote:
>> Give us a test case to demonstrate this assertion. It works as expected
>> AFAICT.
> Ok, it has to do with C functions:
> create or replace function plg_cfie() returns void as '/tmp/plg_cfie.so'
> language c immutable;
You should not declare a function "immutable" if it has side effects
(such as emitting a message). That entitles the planner to pre-evaluate
the function at plan time, which is evidently what's happening here.
regards, tom lane