Re: [GENERAL] Strange order of execution with rule

2005-10-21 Thread Tom Lane
[EMAIL PROTECTED] 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 immut

Re: [GENERAL] Strange order of execution with rule

2005-10-21 Thread han . holl
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: #include #include #include PG_FUNCTION_INFO_V1(plg_cfie); Datum plg_cfie(PG_FUNCTION_ARGS) { struct timeval befo

Re: [GENERAL] Strange order of execution with rule

2005-10-21 Thread han . holl
On Thursday 20 October 2005 23:48, Tom Lane wrote: > Give us a test case to demonstrate this assertion. It works as expected > AFAICT. > Indeed it does. I forgot to mention that the first function to be called was language plruby. Maybe that has anything to do with it. I'll try to come with somet

Re: [GENERAL] Strange order of execution with rule

2005-10-20 Thread Tom Lane
[EMAIL PROTECTED] writes: > I have something like this: > CREATE or replace rule update_rule as on update > to aview > do instead ( > select func_display(new, old); > select rubriek('reset', 0, '', 0); > ); > I tried all kinds of variations (one select with two functions, a

[GENERAL] Strange order of execution with rule

2005-10-20 Thread han . holl
Hello, I have something like this: CREATE or replace rule update_rule as on update to aview do instead ( select func_display(new, old); select rubriek('reset', 0, '', 0); ); (Postgres 8.0.3). I tried all kinds of variations (one select with two functions, and two differ