| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > Hi all,
> >
> > 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
> >
> > COPY esp_altera_estoque, line 1, column nr_cnpjcpf: "24614011000120"
> >
> > The funny is that im 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!
| 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 |