[thuban-Bugs][257] postgis table cannot be opened

[thuban-bugs@wald.intevation.org]

Bugs item #257, was opened at 2007-01-06 02:04
Status: Open
Priority: 3
Submitted By: Didrik Pinte (dpinte)
Assigned to: Nobody (None)
Summary: postgis table cannot be opened 
Resolution: None
Version: None
Category: None


Initial Comment:
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.



----------------------------------------------------------------------

You can respond by visiting: 
http://wald.intevation.org/tracker/?func=detail&atid=105&aid=257&group_id=6