Search Postgresql Archives

Strange order of execution with rule

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 
different update rules with a select each) but in _all_ cases the second 
function is executed before the first, or possibly at the same time (but I 
didn't think the backend is threaded).

Is this known behaviour, and what can I do to change it?

Thanks in advance for any suggestions,

Han Holl

P.S. I don't know if it's relevant but what func_display and rubriek do has 
nothing to do with the database. Let's say they do some kind of logging.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux