Bug report #11739

PostGIS tables with missing geometries

Added by Paolo Cavallini almost 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 #:19973


If one has a pg table with records with a missing geometry (e.g. there are records with a geom in a point column, others in a line column, others with both), the table will show only the records with a geom; if I click on Show all, I also get records without a geom. Of course, selecting a record like this and clicking on Zoom to selected does nothing.
Perhaps it would be better to show only records with a geometry.


#1 Updated by Nyall Dawson almost 9 years ago

I disagree.. I think it's important to show all records, even if they have null geometry. I often with with tables with a mix of geometries and no geometry.

#2 Updated by Paolo Cavallini almost 9 years ago

I see your point, but this has unwanted effects: the user can try to zoom to a feature with NULL geometry, and does not have a clue of why is not working. Perhaps adding an option to show only records with a geom, or greying out those without, would be good.

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

  • Category changed from Data Provider to Data Provider/PostGIS

#4 Updated by Giovanni Manghi over 6 years ago

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

#5 Updated by Paolo Cavallini over 5 years ago

  • Affected QGIS version changed from 2.6.0 to 3.0.0
  • Description updated (diff)

Unchanged in QGIS 3.

Also available in: Atom PDF