Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7UJjdf52061 for ; Thu, 30 Aug 2001 15:45:39 -0400 (EDT) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.117.198]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 427; Thu, 30 Aug 2001 13:37:13 -0600 Message-ID: <3B8E9BE7.83E9D905@waterford.org> Date: Thu, 30 Aug 2001 14:02:47 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Stephan Szabo CC: pgsql-admin@postgresql.org Subject: Re: Re: pg_dumpall failed References: Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/136 X-Sequence-Number: 2075 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.