From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Nelio Alves Pereira Filho <nelio(at)ifx(dot)com(dot)br> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Order of Rules |
Date: | 2001-02-01 17:59:05 |
Message-ID: | 200102011759.MAA08279@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)ifx(dot)com(dot)br
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-02-01 18:44:28 | Re: Re: Disk acces |
Previous Message | Michael Dunn | 2001-02-01 17:56:25 | Obtaining nTuples from a cursor |