Bug report #2445
Problems with table manager and postgis tables
| 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 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 over 14 years ago
Why not? If they got permission to do it, they're assumed safe
#4
Updated by Borys Jurgiel over 14 years ago
- Resolution set to fixed
- Status changed from Open to Closed
fixed in v 0.1.11