Re: error msg when pg_restore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: error msg when pg_restore
Дата
Msg-id 11891.1156281850@sss.pgh.pa.us
обсуждение исходный текст
Ответ на error msg when pg_restore  ("nuno" <wegein@gmail.com>)
Ответы Re: error msg when pg_restore  ("nuno" <wegein@gmail.com>)
Список pgsql-general
"nuno" <wegein@gmail.com> writes:
> when i restore a database (using a backup file), it shows me some error
> messages which do not seem to matter at all (there is no data lost in
> the database, and maybe they're just warning messages...).

> pg_restore: [archiver (db)] could not execute query: ERROR:  function
> public.plp
> gsql_validator(oid) does not exist
>     Command was: DROP FUNCTION public.plpgsql_validator(oid);

Apparently you're using the -c option when there's not really anything
that needs dropping.  -c is for removing existing copies of the database
objects you're restoring.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: using deferred initially deferred to solve foreign key checking issues
Следующее
От: Tom Lane
Дата:
Сообщение: Re: varchar(n) vs. varchar