Re: rule on update

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: rule on update
Дата
Msg-id 24997.1012924208@sss.pgh.pa.us
обсуждение исходный текст
Ответ на rule on update  ("Gerhard Pfeiffer" <gp@bnbt.de>)
Список pgsql-general
"Gerhard Pfeiffer" <gp@bnbt.de> writes:
> It shouldn't show me this error, because the update invoked by the rule
> doesn't fulfill the condition (new.ent_udate=old.ent_udate).

Rules are macros rewritten at planning time, not at execution time,
so you cannot escape the rewrite cycle with an execution-time condition.

You will probably have better luck doing what you want to do with
a trigger.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Getting fields in a table through a query?
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: PostgreSQL v7.2 Final Release