From: | Decibel! <decibel(at)decibel(dot)org> |
---|---|
To: | dguevara <dguevara(at)acceso(dot)com(dot)pe> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Trigger from a function |
Date: | 2008-02-21 23:31:44 |
Message-ID: | 290D84E7-AD9F-45A2-AC4C-F20DAF8238FE@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Feb 18, 2008, at 10:29 AM, dguevara wrote:
> Hello all,
>
> I have a problem with a trigger which is executed when i make an
> UPDATE trought a simple query, but
> not when the UPDATE is made in a store procedure.
>
> Maybe i'm missing something in the declaration of the function and
> i would appreciate any help.
> T
> his is the function:
>
> CREATE OR REPLACE FUNCTION X
> RETURNS SETOF void AS
> $BODY$
>
> begin
> update A;
> end;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
>
>
> The trigger:
>
> CREATE TRIGGER Y
> BEFORE INSERT OR UPDATE
> ON A
> FOR EACH ROW
> EXECUTE PROCEDURE Z;
>
> CREATE OR REPLACE FUNCTION Z
> RETURNS "trigger" AS
> $BODY$
> begin
> if (tg_op in ('INSERT', 'UPDATE', 'DELETE')) then
> update A;
> end if;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
Can't help much with your fake example, but I am wondering why you
have a recursive trigger on A.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
From | Date | Subject | |
---|---|---|---|
Next Message | Decibel! | 2008-02-21 23:32:31 | Re: Table was deleted but it still been treated as not |
Previous Message | Lucian DRAGUS | 2008-02-21 23:31:40 | unsubscribe |