Strange order of execution with rule

Поиск
Список
Период
Сортировка
От han.holl@informationslogik.nl
Тема Strange order of execution with rule
Дата
Msg-id 200510202252.13281.han.holl@informationslogik.nl
обсуждение исходный текст
Ответы Re: Strange order of execution with rule  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Select all invalid e-mail addresses
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: NULL != text ?