Trigger from a function

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

Responses

Browse pgsql-admin by date

  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