Bug report #2445

Problems with table manager and postgis tables

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

Status:Closed
Priority:Low
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

Description

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+
    self.drawFieldsTable()
  File "/home/bjsvwpfe/.qgis//python/plugins/tablemanager/tableManager_gui.py", line 183, in drawFieldsTable
    item = QTableWidgetItem(fields[i].name())
[[KeyError]]: 82

thx

History

#1 Updated by Giovanni Manghi over 10 years ago

meanwhile you can use the "postgis manager" plugin.

#2 Updated by bjpfei - over 10 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 almost 10 years ago

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

#4 Updated by Borys Jurgiel almost 10 years ago

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

fixed in v 0.1.11

Also available in: Atom PDF