Detailed description |
|
Using the latest svn version on a Debian system with psycopg 1, I get the following error while opening a postgis table :
Can't open the database table 'network'
I've updated Thuban/UI/mainwindow.py in order to get more info about the problem . So I've added a str of the Exception to the RunMessageBox call.
Can't open the database table 'network'
ERROR: column "cellgeom" does not exist
SELECT srid, type FROM geometry_columns WHERE f_table_name = '"network"' AND f_geometry_column = cellgeom
This is pretty strange. The table name is quoted and don't have to and the column name is not even single quoted. The corresponding line of code is :
Thuban/Model/postgisdb.py - line 533 :
cursor.execute("SELECT srid, type FROM geometry_columns"
" WHERE f_table_name = %s AND f_geometry_column=%s",
(self.tablename, self.geometry_column))
The postgresql backend is a 8.1 server with latin-1 database and postgis 1.6. My locale are ISO-8859-1.
|
|