Re: Corrupt view in PostgreSQL 9.0.9

=?ISO-8859-1?Q?Mikael_Kjellstr=F6m?= <mikael(dot)kjellstrom(at)mksoft(dot)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 at
select * 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