Trigger from a function

Поиск
Список
Период
Сортировка
От dguevara
Тема Trigger from a function
Дата
Msg-id 20080218161525.M66419@acceso.com.pe
обсуждение исходный текст
Ответы Re: Trigger from a function  (Decibel! <decibel@decibel.org>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Vladimir Rusinov"
Дата:
Сообщение: Re: WAL backups
Следующее
От: biggero@poczta.onet.pl
Дата:
Сообщение: Install 8.3.0-1 on Windows XP