From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Márcio Antônio Sepp <marcio(at)zyontecnologia(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error while running restore |
Date: | 2021-01-21 21:00:52 |
Message-ID: | 636692a0-0910-dfc8-f959-328935bbd73d@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | James B. Byrne | 2021-01-21 21:22:56 | interval data type |
Previous Message | Tommy Li | 2021-01-21 20:54:54 | autovacuum verbose? |