Re: Corrupt view in PostgreSQL 9.0.9 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Corrupt view in PostgreSQL 9.0.9
Date
Msg-id 22618.1348842939@sss.pgh.pa.us
Whole thread Raw
In response to Corrupt view in PostgreSQL 9.0.9  (Mikael Kjellström <mikael.kjellstrom@mksoft.nu>)
Responses Re: Corrupt view in PostgreSQL 9.0.9  (Mikael Kjellström <mikael.kjellstrom@mksoft.nu>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Mikael Kjellström
Date:
Subject: Corrupt view in PostgreSQL 9.0.9
Next
From: urvancevav@gmail.com
Date:
Subject: BUG #7574: CASE in WHERE condition change result set