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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-09-28 14:35:39 | Re: Corrupt view in PostgreSQL 9.0.9 |
Previous Message | urvancevav | 2012-09-28 08:58:42 | BUG #7574: CASE in WHERE condition change result set |