"Ian Harding" <ianh@tpchd.org> writes:
> Can someone tell me how to go about fixing this? I am trying a data only dump, but it seems to need to get a view
definition?
> bash-2.05$ pg_dump -a -d planning > foo
> getTables(): SELECT (for VIEW DEFINITION) failed. Explanation from backend: ERROR: cache lookup for proc 15505994
failed
Evidently you've got a broken view ("broken" meaning "relies on a
function that no longer exists"). You'll need to find and drop that
view.
7.2's pg_dump would tell you exactly which view it's failing on,
but 7.1's doesn't. You could run pg_dump after doing
export PGOPTIONS="-d2"
and then look in the postmaster log to see the queries pg_dump
sends to the backend. The last query before the failure would
tell you which view was being retrieved.
regards, tom lane