Re: Order of Rules

We know we need to change INSERT rules to fire after the command.
Hopefully this will be done in 7.2.

> 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
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026