Re: pg_dump failed

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: pg_dump failed
Дата
Msg-id 20020507084745.U71502-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на pg_dump failed  ("Gaetano Mendola" <mendola@bigfoot.com>)
Список pgsql-admin
On Tue, 7 May 2002, Gaetano Mendola wrote:

> Hi all,
> performing a pg_dump I obtain this error
>
> $ pg_dump empdb > dacan.sql
> getTables(): SELECT (for VIEW DEFINITION) failed.  Explanation from backend:
> ERROR:  cache lookup for proc 117968 failed
>
>
> Anyone have an idea ?

Is it possible that you've got a view referencing a deleted function?
Turning on query logging and seeing what it was trying to do immediately
before the message is probably advisable.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Dying PostgreSQL backend
Следующее
От: "Gaetano Mendola"
Дата:
Сообщение: Re: pg_dump failed