CREATE OR REPLACE FUNCTION go.f_conta_taiu()
    RETURNS trigger
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE NOT LEAKPROOF
AS $BODY$

BEGIN
	set petros.conta_usuario = 'AGO';

	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;