Help! pg_dump: Error message from server: ERROR: cache lookup failed for type 19 - Mailing list pgsql-general

From 夏武
Subject Help! pg_dump: Error message from server: ERROR: cache lookup failed for type 19
Date
Msg-id AANLkTikFqmOg2S6CwLp3K4difxoAH8C2p3XjpD50V5tp@mail.gmail.com
Whole thread Raw
Responses Re: Help! pg_dump: Error message from server: ERROR: cache lookup failed for type 19
List pgsql-general
i use the slony for replication of postgresql database. it work fine some day.
After i use the slony command to delete the replication node, pg_dump does not work, the error message is:
pg_dump: schema with OID 73033 does not exist

Then i delete the name space of slony in  pg_namespace, and pg_dump does not work.
So i delete the data of the name space in pg_class, pg_type, the command is:
DELETE FROM pg_class where relnamespace=73033
DELETE FROM pg_type where relnamespace=73033

i got the error message:
pg_dump: Error message from server: ERROR:  cache lookup failed for type 19

How to fix it? How to recovery the database?
thanks!


wu.xia

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: SQL Programming Question
Next
From: Martin Gainty
Date:
Subject: Re: SQL Programming Question