[Qgis-developer] PostGIS tables with missing gemoetries: how to handle them?

2014-11-20 Thread Paolo Cavallini
Hi all. 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

Re: [Qgis-developer] PostGIS tables with missing gemoetries: how to handle them?

2014-11-20 Thread Bernhard Ströbl
Hi, I wasn't aware of this. Although I do not understand why one should put points and lines in the _same_ table, geometries are allowed to be NULL if the field does not have a NOT NULL constraint. I see two possible solutions 1) mark the dataset as having no geometry 2) (preferred) do only