Re: pg_dump: schema with OID 559701082 does not exist

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_536bm_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:
> Dirk Lutzebäck <lutzeb@aeccom.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