Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION go.f_conta_taiu()
- RETURNS trigger
- LANGUAGE 'plpgsql'
- COST 100
- VOLATILE NOT LEAKPROOF
- AS $BODY$
- BEGIN
- UPDATE public.pessoa
- SET opcional_5 = NEW.chave_autenticacao_armazenamento_dfe
- WHERE guid_pessoa::uuid = NEW.id_cliente;
- RETURN NEW;
- END;
- $BODY$;
- ALTER FUNCTION go.f_conta_taiu()
- OWNER TO adaptive_dba;
- CREATE TRIGGER conta_taiu
- AFTER INSERT OR UPDATE
- ON go.conta
- FOR EACH ROW
- EXECUTE PROCEDURE go.f_conta_taiu();
- GRANT EXECUTE ON FUNCTION go.f_conta_taiu() TO adaptive_dba;
- GRANT EXECUTE ON FUNCTION go.f_conta_taiu() TO postgres;
- GRANT EXECUTE ON FUNCTION go.f_conta_taiu() TO usuariosadaptive;
- GRANT EXECUTE ON FUNCTION go.f_conta_taiu() TO PUBLIC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement