Re: Corrupt view in PostgreSQL 9.0.9

Mikael Kjellström <mikael.kjellstrom@mksoft.nu> writes:
> # drop view communitytaxiexceptions ;
> ERROR:  invalid attribute number 0 for communitytaxiexceptions

That's pretty odd --- it implies something nasty has happened to the
contents of pg_attribute.  It would be interesting to have a look atselect * from pg_attribute where attrelid =
'communitytaxiexceptions'::regclass;

> Is there anything thing I could do to manually remove the view or fix
> the problem?

Well, you could manually remove its pg_class and pg_type rows, and that
should be close enough to being "gone".  But what I'm worried about is
what other damage there is.
        regards, tom lane