=?iso-8859-1?Q?M=E1rcio_Ant=F4nio_Sepp?= <marcio@xxxxxxxxxxxxxxxxxxxxx> 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
