gmocamilotd
1/18/2018 - 3:08 PM

postgres crear triggers

text
content_copyfile_download

DROP TRIGGER trgg_update
  ON public.d01tipodoc; 

DROP TRIGGER trgg_update
  ON public.w10usuario; 

DROP TRIGGER trgg_insert
ON public.d01tipodoc; 


DROP TRIGGER trgg_insert
  ON public.w10usuario; 

/*
CREATE TRIGGER trgg_update
  BEFORE UPDATE
  ON public.d01tipodoc
  FOR EACH ROW
  EXECUTE PROCEDURE public.setmarktimeonfield();

CREATE TRIGGER trgg_update
  BEFORE UPDATE
  ON public.w10usuario
  FOR EACH ROW
  EXECUTE PROCEDURE public.setmarktimeonfield();
  
CREATE TRIGGER trgg_insert
  BEFORE INSERT
  ON public.d01tipodoc
  FOR EACH ROW
  EXECUTE PROCEDURE public.setmarktimeonfield('C');
  
CREATE TRIGGER trgg_insert
  BEFORE INSERT
  ON public.w10usuario
  FOR EACH ROW
  EXECUTE PROCEDURE public.setmarktimeonfield('C');  

*/