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
