I am trying to use the aforementioned plugin with QGIS 1.7 and Postgres 9.0/PostGIS 1.5.
Added a PostGIS spatial layer w/out a problem and then clicked on the RT Sql layer button which displayed the main dialog. When I select Database-> , I got this error
BTW - the ...'s is the QGIS plugin path. Left it out for clarity):
An error has occured while executing Python code: Traceback (most recent call last): File ".../python/plugins\rt_sql_layer\ManagerWindow.py", line 112, in dbConnectSlot self.dbConnect( self.sender() ) File ".../python/plugins\rt_sql_layer\ManagerWindow.py", line 163, in dbConnect self.refreshTable() File ".../python/plugins\rt_sql_layer\ManagerWindow.py", line 272, in refreshTable model.loadFromDb(self.db) File ".../python/plugins\rt_sql_layer\DatabaseModel.py", line 250, in loadFromDb self.tree.constructTreeFromDb(self.db) File ".../python/plugins\rt_sql_layer\DatabaseModel.py", line 96, in constructTreeFromDb list_tables = db.list_geotables() File ".../python/plugins\rt_sql_layer\connectors\postgis.py", line 275, in list_geotables items[i] = geo_item IndexError: list assignment index out of range Python version: 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)] QGIS version: 1.7.0-Wroclaw Wroclaw, 63ecdd7
I never used python in the past but I had a look at the source code and it seems that the query the plugin is running to get the spatial tables into a tree view is not returning anything? Had a go to running the sql statements in PostGIS and they all seem to return data. Then again- not sure if I am looking at the right place!
Have you seen this before? Has it got anything to do with the s/w versions? Plugin was developed for an earlier version and something has changed in the latest?