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