Order of Rules

Поиск
Список
Период
Сортировка
От Nelio Alves Pereira Filho
Тема Order of Rules
Дата
Msg-id 3A77220A.8649F2EE@ifx.com.br
обсуждение исходный текст
Ответы Re: Order of Rules  (adb <adb@Beast.COM>)
Re: Order of Rules  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
I read at the docs that rules are executed before the query that
generated them. Is there any way to change this?

Here's my problem: I have two tables, A and B, and after an INSERT on
table A, I want to update an specific field on table B, with the result
of a sum in A. To do this I needed some information about the row just
inserted, so I used rules. As my sum is running before the insertion,
its result is wrong.

Any ideas?

Tks

--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
+55 11 3365-5863
nelio@ifx.com.br

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

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: Backends dying due to memory exhaustion--I'm stonkered
Следующее
От: "Roderick A. Anderson"
Дата:
Сообщение: Re: design