Re: Error while running restore - Mailing list pgsql-general

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

            regards, tom lane