Re: Re: pg_dumpall failed - Mailing list pgsql-admin

From Oleg Lebedev
Subject Re: Re: pg_dumpall failed
Date
Msg-id 3B8E9BE7.83E9D905@waterford.org
Whole thread Raw
In response to Re: Re: [SQL] HELP: Trend reporting  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Re: pg_dumpall failed  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
I can't find any reference to this table in my current database.
What's the best way to find this out?
thank you,

Oleg

Stephan Szabo wrote:

> On Thu, 30 Aug 2001, Oleg Lebedev wrote:
>
> > Hi,
> > I am trying to upgrade to 7.1.2 and when I use:
> > pg_dumpall -o > file.bac
> > I get an error saying:
> > dumpRules(): SELECT failed for table setmedias. Explanation from backend:
> > 'ERROR: cache lookup of attribute 5 in relation 23945 failed"
> >
> > As I understand setmedias table corresponds to relation 23945, but I dropped
> > it a long time ago. How should remove this relation pointer?
> > thanks,
>
> It sounds like you have a rule that still refers to the dead table.


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Re: [SQL] HELP: Trend reporting
Next
From: Stephan Szabo
Date:
Subject: Re: Re: pg_dumpall failed