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