=?iso-8859-1?Q?M=E1rcio_Ant=F4nio_Sepp?= <marcio@zyontecnologia.com.br> writes:
> Im 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().
regards, tom lane