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


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to