Hi > > I’m getting this error message when try to restore a database : > > ERROR: function f_validanumero_cnpj_cpf(character) does not exist > > LINE 1: SELECT (f_validanumero_cnpj_cpf(trim(cnpj_cpf)::char)=false) > > ^ > > HINT: No function matches the given name and argument types. You might > need > > to add explicit type casts. > > QUERY: SELECT (f_validanumero_cnpj_cpf(trim(cnpj_cpf)::char)=false) > > CONTEXT: função PL/pgSQL public.f_testacnpjcpf(character) linha 31 em IF > > It looks like f_testacnpjcpf() is making unwarranted assumptions about what > search_path it's invoked under. You could try schema-qualifying the > reference to f_validanumero_cnpj_cpf, or adding an explicit "SET > search_path" clause to f_testacnpjcpf().
Thank you. Setting set search_path to f_testacnpjcpf() works fine. Thank you Tom! Thanks list!
