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!