Skip to content

Instantly share code, notes, and snippets.

@gmocamilotd
Created January 18, 2018 15:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gmocamilotd/f563604c365b23fb726dfa28edaa9851 to your computer and use it in GitHub Desktop.
Save gmocamilotd/f563604c365b23fb726dfa28edaa9851 to your computer and use it in GitHub Desktop.
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');
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment