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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-29 20:40:38 | Re: pg_dump: schema with OID 559701082 does not exist |
Previous Message | Martin Pelikan | 2005-11-29 19:38:39 | BUG #2077: Hiding databases which I am not owner |