Обсуждение: Error while running restore

=?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

On 1/21/21 9:52 AM, Márcio Antônio Sepp wrote:
> Hi all,
> 
> 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
> 
> COPY esp_altera_estoque, line 1, column nr_cnpjcpf: "24614011000120"
> 
> The funny is that i’m restoring the database to the same Server.
> 
> Steps:
> 
> pg_dump /dbname/> /dumpfile/
> 
> Create new database and restoring with:
> 
> psql <|/dumpfile/|
> 
> Witch making mistakes do am i making?
> 
> In this case, the database is small and if I open the dumpfile with a 
> notepad and split in 2 files and run after other it works fine.

Split where?

Is this function being used in a TRIGGER on esp_altera_estoque?

> 
> --
> 
> Att
> 
> Márcio A. Sepp
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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!

> > Hi all,
> >
> > 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
> >
> > COPY esp_altera_estoque, line 1, column nr_cnpjcpf: "24614011000120"
> >
> > The funny is that i’m restoring the database to the same Server.
> >
> > Steps:
> >
> > pg_dump /dbname/> /dumpfile/
> >
> > Create new database and restoring with:
> >
> > psql <|/dumpfile/|
> >
> > Witch making mistakes do am i making?
> >
> > In this case, the database is small and if I open the dumpfile with a
> > notepad and split in 2 files and run after other it works fine.
>
> Split where?
Dabase is very small. I open the dump file and with Ctrl X and Ctrl V I
create 2 news files. Than run in order each file.

> Is this function being used in a TRIGGER on esp_altera_estoque?
yes

Thank You Adrian and list!