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

Re: pg_dump: schema with OID 559701082 does not exist

From: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump: schema with OID 559701082 does not exist
Date: 2005-11-29 20:13:13
Message-ID: 438CB659.6080600@aeccom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I have found and deleted an entry with pg_class.relnamespace=559701082 
but nowhere else. I still cannot dump the schema. Is there something 
like a system catalog integrity checker?

The problem I'm facing is the following:

cs1=# select relname from pg_class where relname like 'bm%';
               relname
-----------------------------------
  bm_pagehits_1133271374_047421_941
  bm_pagehits_1133271378_920896_129
  bm_pagehits_1133282272_744243_536
  bm_pagehits_1133284780_743839_884
(4 rows)

cs1=# drop table bm_pagehits_1133271374_047421_941;
ERROR:  table "bm_pagehits_1133271374_047421_941" does not exist
cs1=# drop table bm_pagehits_1133271378_920896_129;
ERROR:  table "bm_pagehits_1133271378_920896_129" does not exist
cs1=# drop table bm_pagehits_1133282272_744243_536;
ERROR:  table "bm_pagehits_1133282272_744243_536" does not exist
cs1=# drop table bm_pagehits_1133284780_743839_884;
ERROR:  table "bm_pagehits_1133284780_743839_884" does not exist





Tom Lane wrote:
> =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb(at)aeccom(dot)com> writes:
> 
>>I get the following error when I call:
>># pg_dump  db
>>pg_dump: schema with OID 559701082 does not exist
> 
> 
> I suspect a corrupted catalog entry.  Look through your system catalogs
> for an entry referring to namespace 559701082 --- you want to look in
> pg_class.relnamespace, pg_proc.pronamespace, etc.
> 
> 			regards, tom lane


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-11-29 20:40:38
Subject: Re: pg_dump: schema with OID 559701082 does not exist
Previous:From: Martin PelikanDate: 2005-11-29 19:38:39
Subject: BUG #2077: Hiding databases which I am not owner

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