Bug report #9651

PostGIS polyhedral and TIN layers not handled anymore

Added by Hugo Mercier over 5 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:Jürgen Fischer
Category:Data Provider/PostGIS
Affected QGIS version:2.2.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 #:18219

Description

PostGIS tables with geometries of type PolyhedralSurface or TIN cannot be loaded anymore :
  • no correct type is detected when using "add a postgres layer" (should be MultiPolygon)
  • whatever type is manually selected, it segfaults in QgsGeometry when parsing the wkb

Related issues

Related to QGIS Application - Bug report #9032: LINESTRINGM not displayed Closed 2013-11-08
Related to QGIS Application - Bug report #9748: PostGIS table loads but won't display. Closed 2014-03-08

Associated revisions

Revision cb919e97
Added by Jürgen Fischer over 5 years ago

postgres provider: consider TIN and POLYHEDRALSURFACE as MULTIPOLYGONM (instead of POLYGONM) (fixes #9651)

Revision 9ed98a06
Added by Jürgen Fischer over 4 years ago

postgres provider: restore behaviour to keep 3d wkb (refs #9651,
followup bd311c8)

Revision c7234cee
Added by Jürgen Fischer over 4 years ago

postgres provider: restore behaviour to keep 3d wkb (refs #9651,
followup bd311c8)

History

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

Please attach some data.

#2 Updated by Jürgen Fischer over 5 years ago

  • Status changed from Open to Feedback

#3 Updated by Hugo Mercier over 5 years ago

Data sample, one table with a polyhedral and the other with a TIN :

create table test_polyhedral ( id serial );
select addgeometrycolumn('test_polyhedral', 'geom', 4326, 'POLYHEDRALSURFACE', 3);
insert into test_polyhedral (id,geom) values (1, 'SRID=4326;POLYHEDRALSURFACE Z(((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0)))'::geometry);

create table test_tin ( id serial );
select addgeometrycolumn('test_tin', 'geom', 4326, 'TIN', 3);
insert into test_tin (id,geom) values (1, 'SRID=4326;TIN(((0 0 0,0 1 0,1 1 0,0 0 0)))'::geometry);

#4 Updated by Jürgen Fischer over 5 years ago

  • Status changed from Feedback to Closed

#5 Updated by Sandro Santilli over 5 years ago

Is commit:c3a28177 the backport to 2.2 branch ?

#6 Updated by Jürgen Fischer over 5 years ago

Sandro Santilli wrote:

Is commit:c3a28177 the backport to 2.2 branch ?

$ git branch --contains c3a28177
release-2_2

Also available in: Atom PDF