[postgis-tickets] [PostGIS] #3764: PostGIS topology failures on PostgreSQL 10

PostGIS trac at osgeo.org
Thu May 25 23:31:38 PDT 2017 

#3764: PostGIS topology failures on PostgreSQL 10
-----------------------+---------------------------
  Reporter:  robe      |      Owner:  robe
      Type:  defect    |     Status:  assigned
  Priority:  blocker   |  Milestone:  PostGIS 2.4.0
 Component:  topology  |    Version:  trunk
Resolution:            |   Keywords:
-----------------------+---------------------------
Description changed by robe:

Old description:

> After I was done fixing all the raster issues with PostgreSQL 10,
> surprise surprise.  topology has issues too.
>

> {{{
> Creating database 'postgis_reg'
> Loading PostGIS into 'postgis_reg'
> Loading Topology into 'postgis_reg'
> PostgreSQL 10beta1 on x86_64-w64-mingw32, compiled by gcc.exe
> (x86_64-win32-seh-rev4, Built by MinGW-W64 project) 4.9.2, 64-bit
>   Postgis 2.4.0dev - r15404 - 2017-05-26 06:16:27
>   scripts 2.4.0dev r15404
>   GEOS: 3.7.0dev-CAPI-1.11.0 8fe2ce6
>   PROJ: Rel. 4.9.1, 04 March 2015
>
> Running tests
>
>  regress/legacy_validate .. ok
>  regress/legacy_predicate .. ok
>  regress/legacy_invalid .. ok
>  regress/sqlmm .. ok
>  regress/legacy_query .. ok
>  regress/addnode .. ok
>  regress/addedge .. ok
>  regress/addface .. ok
>  regress/addface2.5d .. ok
>  regress/addtopogeometrycolumn .. ok
>  regress/polygonize .. ok
>  regress/st_addisoedge .. ok
>  regress/st_addisonode .. ok
>  regress/st_addedgemodface .. ok
>  regress/st_addedgenewfaces .. ok
>  regress/st_changeedgegeom .. ok
>  regress/st_createtopogeo .. ok
>  regress/st_getfacegeometry .. ok
>  regress/st_getfaceedges .. ok
>  regress/st_modedgeheal .. ok
>  regress/st_modedgesplit .. ok
>  regress/st_newedgeheal .. ok
>  regress/st_newedgessplit .. ok
>  regress/st_remedgenewface .. ok
>  regress/st_remedgemodface .. ok
>  regress/st_simplify .. failed (diff expected obtained:
> /projects/postgis/tmp/2.4_pg10w64/test_26_diff)
>  regress/topoelement .. ok
>  regress/topoelementarray_agg .. ok
>  regress/topogeo_addlinestring .. ok
>  regress/topogeo_addpoint .. ok
>  regress/topogeo_addpolygon .. ok
>  regress/topogeom_edit .. failed (diff expected obtained:
> /projects/postgis/tmp/2.4_pg10w64/test_32_diff)
>  regress/topogeometry_type .. ok
>  regress/topojson .. ok
>  regress/topologysummary .. ok
>  regress/topo2.5d .. ok
>  regress/totopogeom .. failed (diff expected obtained:
> /projects/postgis/tmp/2.4_pg10w64/test_37_diff)
>  regress/droptopology .. ok
>  regress/droptopogeometrycolumn .. ok
>  regress/copytopology .. failed (diff expected obtained:
> /projects/postgis/tmp/2.4_pg10w64/test_40_diff)
>  regress/createtopogeom .. ok
>  regress/createtopology .. ok
>  regress/gml .. ok
>  regress/getnodebypoint .. ok
>  regress/getedgebypoint .. ok
>  regress/getfacebypoint .. ok
>  regress/getringedges .. ok
>  regress/gettopogeomelements .. ok
>  regress/layertrigger .. ok
>  regress/validatetopology .. ok
>  uninstall .. ok (4662)
>
> Run tests: 51
> Failed: 4
>
> }}}

New description:

 After I was done fixing all the raster issues with PostgreSQL 10, surprise
 surprise.  topology has issues too.


 {{{
 Creating database 'postgis_reg'
 Loading PostGIS into 'postgis_reg'
 Loading Topology into 'postgis_reg'
 PostgreSQL 10beta1 on x86_64-w64-mingw32, compiled by gcc.exe
 (x86_64-win32-seh-rev4, Built by MinGW-W64 project) 4.9.2, 64-bit
   Postgis 2.4.0dev - r15404 - 2017-05-26 06:16:27
   scripts 2.4.0dev r15404
   GEOS: 3.7.0dev-CAPI-1.11.0 8fe2ce6
   PROJ: Rel. 4.9.1, 04 March 2015

 Running tests

  regress/legacy_validate .. ok
  regress/legacy_predicate .. ok
  regress/legacy_invalid .. ok
  regress/sqlmm .. ok
  regress/legacy_query .. ok
  regress/addnode .. ok
  regress/addedge .. ok
  regress/addface .. ok
  regress/addface2.5d .. ok
  regress/addtopogeometrycolumn .. ok
  regress/polygonize .. ok
  regress/st_addisoedge .. ok
  regress/st_addisonode .. ok
  regress/st_addedgemodface .. ok
  regress/st_addedgenewfaces .. ok
  regress/st_changeedgegeom .. ok
  regress/st_createtopogeo .. ok
  regress/st_getfacegeometry .. ok
  regress/st_getfaceedges .. ok
  regress/st_modedgeheal .. ok
  regress/st_modedgesplit .. ok
  regress/st_newedgeheal .. ok
  regress/st_newedgessplit .. ok
  regress/st_remedgenewface .. ok
  regress/st_remedgemodface .. ok
  regress/st_simplify .. failed (diff expected obtained:
 /projects/postgis/tmp/2.4_pg10w64/test_26_diff)
  regress/topoelement .. ok
  regress/topoelementarray_agg .. ok
  regress/topogeo_addlinestring .. ok
  regress/topogeo_addpoint .. ok
  regress/topogeo_addpolygon .. ok
  regress/topogeom_edit .. failed (diff expected obtained:
 /projects/postgis/tmp/2.4_pg10w64/test_32_diff)
  regress/topogeometry_type .. ok
  regress/topojson .. ok
  regress/topologysummary .. ok
  regress/topo2.5d .. ok
  regress/totopogeom .. failed (diff expected obtained:
 /projects/postgis/tmp/2.4_pg10w64/test_37_diff)
  regress/droptopology .. ok
  regress/droptopogeometrycolumn .. ok
  regress/copytopology .. failed (diff expected obtained:
 /projects/postgis/tmp/2.4_pg10w64/test_40_diff)
  regress/createtopogeom .. ok
  regress/createtopology .. ok
  regress/gml .. ok
  regress/getnodebypoint .. ok
  regress/getedgebypoint .. ok
  regress/getfacebypoint .. ok
  regress/getringedges .. ok
  regress/gettopogeomelements .. ok
  regress/layertrigger .. ok
  regress/validatetopology .. ok
  uninstall .. ok (4662)

 Run tests: 51
 Failed: 4

 }}}


 {{{
 --- regress/st_simplify_expected        2016-04-27 10:57:37.693736400
 -0400
 +++ /projects/postgis/tmp/2.4_pg10w64/test_26_out       2017-05-26
 02:22:17.991281200 -0400
 @@ -1,9 +1,8 @@
  t
  L1
 -N2
 -S1|f|t
 -S2|f|t
 +ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +N1
 +S1|f|
 +S2|f|
  L2
 -HS1|f|t
 -HS2|f|t
  f

 --- regress/topogeom_edit_expected      2016-04-27 10:57:37.669735100
 -0400
 +++ /projects/postgis/tmp/2.4_pg10w64/test_32_out       2017-05-26
 02:22:20.196285100 -0400
 @@ -1,8 +1,5 @@
  create|t
  simple_line_layer|1
 -1|start|1|10
 -1|add|1|30
 -1|rem|1|20
 -1|dup|1|20
 -1|mis|1|20
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
  Topology 'tt' dropped


 --- regress/totopogeom_expected 2016-04-27 10:57:37.107702900 -0400
 +++ /projects/postgis/tmp/2.4_pg10w64/test_37_out       2017-05-26
 02:22:21.906287500 -0400
 @@ -18,13 +18,13 @@
  ERROR:  Unsupported feature type TIN
  ERROR:  Unsupported feature type TRIANGLE
  ERROR:  Unsupported feature type CIRCULARSTRING
 -POINT(0 0)|t
 -LINESTRING(0 10,10 10)|t
 -POLYGON((0 20,10 20,5 30,0 20),(2 22,8 22,5 28,2 22))|t
 -MULTIPOINT(0 -10,5 -10)|t
 -MULTILINESTRING((-1 10,-10 10),(-10 8,-2 9))|t
 -MULTIPOLYGON(((100 20,110 20,105 30,100 20),(102 22,108 22,105 28,102
 22)),((80 20,90 20,90 60,80 20)))|t
 -GEOMETRYCOLLECTION(POINT(-100 -100),LINESTRING(-100 -90,-90
 -90),POLYGON((-100 -80,-90 -80,-95 -70,-100 -80),(-98 -78,-92 -78,-95
 -72,-98 -78)),MULTIPOINT(-100 -110,-95 -110),LINESTRING
 EMPTY,MULTILINESTRING((-101 -90,-110 -90),(-110 -92,-102
 -91)),MULTIPOLYGON(((0 -80,10 -80,5 -70,0 -80),(2 -78,8 -78,5 -72,2
 -78)),((-20 -80,-10 -80,-10 -40,-20
 -80))))|GEOMETRYCOLLECTION(MULTIPOLYGON(((-100 -80,-95 -70,-90 -80,-100
 -80),(-98 -78,-92 -78,-95 -72,-98 -78)),((0 -80,5 -70,10 -80,0 -80),(2
 -78,8 -78,5 -72,2 -78)),((-20 -80,-10 -40,-10 -80,-20
 -80))),MULTILINESTRING((-110 -92,-102 -91),(-101 -90,-110 -90),(-100
 -90,-90 -90)),MULTIPOINT(-100 -110,-100 -100,-95 -110))
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
  MULTIPOINT EMPTY
  MULTIPOINT EMPTY
  MULTILINESTRING EMPTY
 @@ -32,21 +32,19 @@
  MULTIPOLYGON EMPTY
  MULTIPOLYGON EMPTY
  GEOMETRYCOLLECTION EMPTY
 -tolerance_1|0.5
 -tolerance_topo_1|0.5
 -tolerance_0|0
 -custom_search_path|0
 -#1790.1|0|0
 -#1790.2|0|0
 -#1790.3|0|0
 -#1968.1|0
 -#1968.2|0
 -tgup1.1|5|100|1
 -tgup1.2|5|200|2
 -tgup1.3|5|200|4
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (POINT) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring,
 expected LINESTRING
  #3359.setval|1|2|1
 -#3359.line.1|1
 -#3359.line.2|2
 -#3359.area.1|1
 -#3359.area.2|2
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (LINESTRING) passed to TopoGeo_AddPolygon,
 expected POLYGON
 +ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring,
 expected LINESTRING
 +ERROR:  Invalid geometry type (POLYGON) passed to TopoGeo_AddLinestring,
 expected LINESTRING
  Topology 'tt' dropped


 --- regress/copytopology_expected       2016-04-27 10:57:36.714680400
 -0400
 +++ /projects/postgis/tmp/2.4_pg10w64/test_40_out       2017-05-26
 02:22:23.096289200 -0400
 @@ -19,13 +19,13 @@
  1|CITY_data_UP_down|LAYER1|
  2|CITY_data_UP_down|LAYER2|
  3|CITY_data_UP_down|LAYER3|
 -node_node_id_seq|22|1|1|9223372036854775807|1|1|0|f|t
 -edge_data_edge_id_seq|26|1|1|9223372036854775807|1|1|0|f|t
 -face_face_id_seq|9|1|1|9223372036854775807|1|1|0|f|t
 -layer_id_seq|1|1|1|9223372036854775807|1|1|f|f
 -topogeo_s_1|9|1|1|9223372036854775807|1|1|0|f|t
 -topogeo_s_2|8|1|1|9223372036854775807|1|1|0|f|t
 -topogeo_s_3|8|1|1|9223372036854775807|1|1|0|f|t
 +22|0|t
 +26|0|t
 +9|0|t
 +ERROR:  column "sequence_name" does not exist at character 8
 +9|0|t
 +8|0|t
 +8|0|t
  Topology 'CITY_data_UP_down' dropped
  Topology 'city_data' dropped
  #2184.1|t

 }}}

--

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3764#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.

More information about the postgis-tickets mailing list