Bug report #2445

Problems with table manager and postgis tables

Added by bjpfei - over 14 years ago. Updated almost 14 years ago.

Assignee:Borys Jurgiel
Category:Python plugins
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:12505


It seems that the table manager doesn't work with postgis tables that don't have the geometry column as last column.

1.) Try a shapefile => Table Manger works

2.) Try a postgis Table with geometry column as last column => Table manager works

3.) try a postgis table with geometry column not as last column => you get an python error

Traceback (most recent call last):
  File "/home/bjsvwpfe/.qgis//python/plugins/tablemanager/tableManager_plugin.py", line 63, in run
    dialoga = tableManager_gui.TableManager(self.iface)
  File "/home/bjsvwpfe/.qgis//python/plugins/tablemanager/tableManager_gui.py", line 173, in +init+
  File "/home/bjsvwpfe/.qgis//python/plugins/tablemanager/tableManager_gui.py", line 183, in drawFieldsTable
    item = QTableWidgetItem(fields[i].name())
[[KeyError]]: 82



#1 Updated by Giovanni Manghi over 14 years ago

meanwhile you can use the "postgis manager" plugin.

#2 Updated by bjpfei - over 14 years ago

me yes but not our users.
It's not that good if they edit the tables directly on the database ;-)

#3 Updated by Paolo Cavallini about 14 years ago

Why not? If they got permission to do it, they're assumed safe

#4 Updated by Borys Jurgiel almost 14 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

fixed in v 0.1.11

Also available in: Atom PDF