[QGIS-Developer] QGIS does not process PostgreSQL columns with geometry(Geometry, 4326)

[wambacher at posteo.de]

Hi,

in OpenStreetMap PostgreSQL/PostGIS database there is a table with a
geometry of type "geometry(Geometry,4326)".

see

 \d+ planet_osm_polygon
 ...
 way                             | geometry(Geometry,4326)
|              |               |             | main       
|               |
 pointonsurface                  | geometry(Point,4326)   
|              |               |             | main       
|               |
 bbox                            | geometry(Polygon,4326) 
|              |               |             | main       
|               | 
 ...

The geometry column "way" is not visible in the layer dialog
(Layer/Layer hinzufügen/PostGIS Layer hinzufügen/):

see
https://wambachers-osm.website/images/osm/snaps_2019/tn_qgis_geometry_problem.png
and
https://wambachers-osm.website/images/osm/snaps_2019/tn_qgis_geometry_problem2.png

Creating views does help, but performance is very poor. That work around
should not be necessary, i think.

This table is really big: >300 GB without indices, 406.807.497 rows,
permanently growing.

Because that is an osm core table, i can't change the geometry of this
column (way) to "geometry( MultiPolygon, 4326)"  because i can't be
shure everything will be running fine after this change. Or will fail if
some core software has been changed.

QGIS 3.8.0 but older releases too. IIRC 2.x was ok.

any ideas?

Regards

walter

-- 

My projects:

Admin Boundaries of the World <https://wambachers-osm.website/boundaries>
Missing Boundaries
<https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries>
Emergency Map <https://wambachers-osm.website/emergency>
Postal Code Map (Germany only) <https://wambachers-osm.website/plz>
Fools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools>
Postcode Boundaries of Germany <https://wambachers-osm.website/pcoundaries>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190704/becb0964/attachment.html>