[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    RES: Error while running restore [SOLVED]
From:       Márcio_Antônio_Sepp <marcio () zyontecnologia ! com ! br>
Date:       2021-01-22 17:53:39
Message-ID: 005701d6f0e7$841727f0$8c4577d0$ () com ! br
[Download RAW message or body]

> > 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!




[prev in list] [next in list] [prev in thread] [next in thread]