Re: pg_dump failed - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump failed
Date
Msg-id 25885.990457400@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump failed  (Leonid <leo@rusmedia.net>)
List pgsql-admin
Leonid <leo@rusmedia.net> writes:
> pg_dump failed with message
> getTables(): SELECT (for VIEW DEFINITION) failed.
> Explanation from backend: ERROR:  cache lookup for proc 372947 failed

> Where I should dig?

You have a view that refers to a function that no longer exists.

Philip: seems like it would be helpful if this pg_dump message mentioned
*which* viewname it was failing on.  There are other cases where more
info could be reported, too...

            regards, tom lane

pgsql-admin by date:

Previous
From: twanger@smartvia.de
Date:
Subject: Re: simpler query significantly slower
Next
From: Peter Eisentraut
Date:
Subject: Re: cannot connect using terminal nor pgaccess