Re: Re: [SQL] HELP: Trend reporting - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Re: [SQL] HELP: Trend reporting
Date
Msg-id Pine.BSF.4.21.0108301212090.54353-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: [SQL] HELP: Trend reporting  (Oleg Lebedev <olebedev@waterford.org>)
List pgsql-admin
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: "Daniel Bakken"
Date:
Subject: Re: Help request
Next
From: Oleg Lebedev
Date:
Subject: Re: Re: pg_dumpall failed