From: | Nelio Alves Pereira Filho <nelio(at)ifx(dot)com(dot)br> |
---|---|
To: | adb <adb(at)Beast(dot)COM> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Order of Rules |
Date: | 2001-01-30 21:15:01 |
Message-ID: | 3A772ED5.28CA8A8@ifx.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes, but how can I pass a reference of the row just inserted to the
trigger??
adb wrote:
>
> Sounds like you need to use a trigger set to
> fire after the insert on table A
>
> Alex.
>
> On Tue, 30 Jan 2001, Nelio Alves Pereira Filho wrote:
>
> > 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
> >
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
+55 11 3365-5863
nelio(at)ifx(dot)com(dot)br
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fork | 2001-01-30 21:28:29 | Re: Order of Rules |
Previous Message | adb | 2001-01-30 20:48:19 | Re: Order of Rules |