RES: Error while running restore [SOLVED]

Поиск
Список
Период
Сортировка
От Márcio Antônio Sepp
Тема RES: Error while running restore [SOLVED]
Дата
Msg-id 005701d6f0e7$841727f0$8c4577d0$@com.br
обсуждение исходный текст
Ответ на Re: Error while running restore  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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!





В списке pgsql-general по дате отправления:

Предыдущее
От: Márcio Antônio Sepp
Дата:
Сообщение: RES: Error while running restore
Следующее
От: Rob Sargent
Дата:
Сообщение: localhost ssl