Re: Corrupt view in PostgreSQL 9.0.9

Mikael Kjellström <mikael.kjellstrom@mksoft.nu> writes:
> I tried the reindex and then the manual delete of the view from
> pg_class.  That took care of the rows in pg_attribute but when I tried
> to run pg_dump I now get this:

> pg_dump: failed sanity check, parent table OID 16547 of pg_rewrite entry
> OID 16550 not found

Oh, okay, pg_dump is doing more cross-checking than I remembered.
That's the ON SELECT rule for the broken view.  You'll need to delete it
manually too, and perhaps also the pg_type row if pg_dump chances to
notice that.  I doubt you'll need to clean up the pg_attribute rows.
        regards, tom lane