CREATE OR REPLACE FUNCTION TRIG_FUNC () RETURNS OPAQUE AS '
BEGIN
   insert into system_data values(
   OLD.mancode,
   OLD.mcode,
   OLD.billnum,
   OLD.distcode,
   OLD.servno,
   OLD.billdate,
   OLD.paydate,
   OLD.amount,
   OLD.cycle,
   OLD.acd,
   OLD.sbmno,
   OLD.rcfee,
   OLD.slabtype,
   OLD.chk_server);
   RETURN NEW;
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER TRIG_TRANS BEFORE UPDATE OR DELETE ON TRANSMAST
FOR EACH ROW EXECUTE PROCEDURE TRIG_FUNC();