Skip site navigation (1) Skip section navigation (2)

Re: Corrupt view in PostgreSQL 9.0.9

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mikael Kjellström <mikael(dot)kjellstrom(at)mksoft(dot)nu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Corrupt view in PostgreSQL 9.0.9
Date: 2012-09-28 14:35:39
Message-ID: 22618.1348842939@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
=?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


In response to

Responses

pgsql-bugs by date

Next:From: Mikael KjellströmDate: 2012-09-28 16:04:00
Subject: Re: Corrupt view in PostgreSQL 9.0.9
Previous:From: Mikael KjellströmDate: 2012-09-28 14:09:47
Subject: Corrupt view in PostgreSQL 9.0.9

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group