From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
---|---|
To: | "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump failed |
Date: | 2002-05-07 17:06:56 |
Message-ID: | 017301c1f5e9$98128460$d5a9fea9@GMENDOLA2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:
> 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.
I did,
may be is a good idea put on that message which view is wrong, or anyway
skip the view with just a warning message.
Ciao
Gaetano
From | Date | Subject | |
---|---|---|---|
Next Message | Bojan Belovic | 2002-05-07 19:08:37 | Re: db recovery (FATAL 2) |
Previous Message | Stephan Szabo | 2002-05-07 15:48:37 | Re: pg_dump failed |