From: | "dguevara" <dguevara(at)acceso(dot)com(dot)pe> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Trigger from a function |
Date: | 2008-02-18 16:29:51 |
Message-ID: | 20080218161525.M66419@acceso.com.pe |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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;
Thanks in advance.
Danilo Guevara
Departamento de Sistemas
Acceso Crediticio SAC
From | Date | Subject | |
---|---|---|---|
Next Message | Vishal Arora | 2008-02-18 17:23:45 | Re: Install 8.3.0-1 on Windows XP |
Previous Message | Vladimir Rusinov | 2008-02-18 16:25:44 | Re: WAL backups |