Trigger to create copies on historical effects (Posgre SQL).

db_trigger.sql

-- INICIO - CATALOGOITEM - Criando FUNCTION E TRIGGER.
CREATE OR REPLACE FUNCTION catalogo.fn_h_catalogoitem()
  RETURNS trigger LANGUAGE plpgsql
AS
'begin
  INSERT INTO catalogo.h_catalogoitem
  (
    ctiid, ctinome, ctidsc, ctistatus, ctilinkreferencia, ctiitemrelacionado, ctlcod, grdid, gpiid, sgiid, apsid, undid, arqid,
    ctidtcadastro, ctidtalteracao, usucpfcadastro, usucpfalteracao
  )
  VALUES
    (
      new.ctiid,
      new.ctinome,
      new.ctidsc,
      new.ctistatus,
      new.ctilinkreferencia,
      new.ctiitemrelacionado,
      new.ctlcod,
      new.grdid,
      new.gpiid,
      new.sgiid,
      new.apsid,
      new.undid,
      new.arqid,
      new.ctidtcadastro,
      new.ctidtalteracao,
      new.usucpfcadastro,
      new.usucpfalteracao
    );
      return new;
end;';
CREATE TRIGGER tg_h_catalogoitem AFTER INSERT OR UPDATE
ON catalogo.catalogoitem FOR EACH ROW
EXECUTE PROCEDURE catalogo.fn_h_catalogoitem();
-- FIM - CATALOGOITEM - Criando FUNCTION E TRIGGER.