Bug report #9440

Do not show DB geometric columns in table view

Added by Paolo Cavallini about 10 years ago. Updated about 6 years ago.

Status:Open
Priority:Normal
Assignee:-
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

Description

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.

History

#1 Updated by Jürgen Fischer almost 9 years ago

  • Category changed from Data Provider to Data Provider/PostGIS

#2 Updated by Giovanni Manghi almost 7 years ago

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

#3 Updated by Paolo Cavallini about 6 years ago

  • Description updated (diff)

Still true in QGIS 3

#4 Updated by Giovanni Manghi about 6 years ago

  • Affected QGIS version changed from 2.0.1 to 3.0.0

Also available in: Atom PDF