From: | Márcio Antônio Sepp <marcio(at)zyontecnologia(dot)com(dot)br> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RES: Error while running restore |
Date: | 2021-01-22 17:49:10 |
Message-ID: | 005001d6f0e6$e38c5ee0$aaa51ca0$@com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Márcio Antônio Sepp | 2021-01-22 17:53:39 | RES: Error while running restore [SOLVED] |
Previous Message | Keith Christian | 2021-01-22 16:01:40 | Re: Customer unable to connect on port 5432, Postgres 10.7 |