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

Corrupt view in PostgreSQL 9.0.9

From: Mikael Kjellström <mikael(dot)kjellstrom(at)mksoft(dot)nu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Corrupt view in PostgreSQL 9.0.9
Date: 2012-09-28 14:09:47
Message-ID: 5065AFAB.1030305@mksoft.nu (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

First some info about the machine and the postgres version:

os: Debian 6.0.5 (64-bit)

postgres version: PostgreSQL 9.0.9 on x86_64-unknown-linux-gnu, compiled 
by GCC gcc (Debian 4.4.5-8) 4.4.5, 64-bit

The problem:
I first noticed pg_dump giving the following error message when trying 
to dump the database:

pg_dump: invalid column numbering in table "communitytaxiexceptions"

then when I connect to the database with psql and try to drop the view I 
get the following error:

# drop view communitytaxiexceptions ;
ERROR:  invalid attribute number 0 for communitytaxiexceptions

and a select gives the same error message:

# select * from communitytaxiexceptions ;
ERROR:  invalid attribute number 0 for communitytaxiexceptions
LINE 1: select * from communitytaxiexceptions ;
                       ^
Is there anything thing I could do to manually remove the view or fix 
the problem?

Thanks in advance,
Mikael


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-09-28 14:35:39
Subject: Re: Corrupt view in PostgreSQL 9.0.9
Previous:From: urvancevavDate: 2012-09-28 08:58:42
Subject: BUG #7574: CASE in WHERE condition change result set

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