RES: Error while running restore [SOLVED]

From: Márcio Antônio Sepp <marcio(at)zyontecnologia(dot)com(dot)br>
To: "'Adrian Klaver'" <adrian(dot)klaver(at)aklaver(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: RES: Error while running restore [SOLVED]
Date: 2021-01-22 17:53:39
Message-ID: 005701d6f0e7$841727f0$8c4577d0$@com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2021-01-22 19:04:13 localhost ssl
Previous Message Márcio Antônio Sepp 2021-01-22 17:49:10 RES: Error while running restore