| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Márcio Antônio Sepp <marcio(at)zyontecnologia(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Error while running restore |
| Date: | 2021-01-21 18:41:29 |
| Message-ID: | 916106.1611254489@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
=?iso-8859-1?Q?M=E1rcio_Ant=F4nio_Sepp?= <marcio(at)zyontecnologia(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Tanzer | 2021-01-21 19:09:13 | Re: Copy & Re-copy of DB |
| Previous Message | Márcio Antônio Sepp | 2021-01-21 17:59:10 | RES: Error while running restore |