Re: Strange order of execution with rule

han.holl@informationslogik.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