Skip site navigation (1) Skip section navigation (2)

Re: Re: pg_dumpall failed

From: Oleg Lebedev <olebedev(at)waterford(dot)org>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Re: pg_dumpall failed
Date: 2001-08-30 20:02:47
Message-ID: 3B8E9BE7.83E9D905@waterford.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
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.


In response to

Responses

pgsql-admin by date

Next:From: Stephan SzaboDate: 2001-08-30 20:06:46
Subject: Re: Re: pg_dumpall failed
Previous:From: Stephan SzaboDate: 2001-08-30 19:58:18
Subject: Re: Re: pg_dumpall failed

pgsql-sql by date

Next:From: Stephan SzaboDate: 2001-08-30 20:06:46
Subject: Re: Re: pg_dumpall failed
Previous:From: Stephan SzaboDate: 2001-08-30 19:58:18
Subject: Re: Re: pg_dumpall failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group