Bug report #9440

Do not show DB geometric columns in table view

Added by Paolo Cavallini over 9 years ago. Updated over 5 years ago.

Category:Data Provider/PostGIS
Affected QGIS version:3.0.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:18034


When there is only one column in a database table, it is displayed on the canvas, and nothing is shown on the table itself.
If there is >1 geom column, all those not displayed in the canvas are shown on the table. This has several problems:
  • it is confusing for the user
  • it slows down table reading considerably
  • it may cause loss of data if the user accidentally modifies the WKT geometry displayed (untested).
    Better not displaying any geometry column.


#1 Updated by Jürgen Fischer over 8 years ago

  • Category changed from Data Provider to Data Provider/PostGIS

#2 Updated by Giovanni Manghi over 6 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by Paolo Cavallini over 5 years ago

  • Description updated (diff)

Still true in QGIS 3

#4 Updated by Giovanni Manghi over 5 years ago

  • Affected QGIS version changed from 2.0.1 to 3.0.0

Also available in: Atom PDF