[postgis-tickets] [PostGIS] #3329: Topology population regression

PostGIS trac at osgeo.org
Sat Oct 10 07:48:47 PDT 2015


#3329: Topology population regression
----------------------+---------------------------
 Reporter:  strk      |      Owner:  strk
     Type:  defect    |     Status:  new
 Priority:  blocker   |  Milestone:  PostGIS 2.2.1
Component:  topology  |    Version:  2.2.x
 Keywords:            |
----------------------+---------------------------
 Another regression spotted between plpgsql and C version of topology
 loading.
 I'm attaching the smallest input found so far, can probably be further
 reduced. Thanks @esseffe for finding this out.

 To reproduce the error:
 {{{
 strk=# select createtopology('rer_exception');
  createtopology
 ----------------
            2650
 (1 row)


 strk=# select topogeo_addpolygon('rer_exception', st_geometryn(geom, 1))
 from rer_exception order by gid;
 ERROR:  SQL/MM Spatial exception - geometry crosses edge 58
 }}}

 Switching to the plpgsql version works and returns 60 faces (with a few
 duplicates and a null, which isn't really expected):
 {{{
 ALTER EXTENSION
 strk=# select topogeo_addpolygon('rer_exception', st_geometryn(geom, 1))
 from rer_exception order by gid;
  topogeo_addpolygon
 --------------------
                  71
                  84
                  71
                  72
                  74
                  76
                  78
                  80
                  82
                  86
                  89
                  91
                  93
                  95
                  96
                  97
                  99
                  87
                  76
                  80
                  88
                  90
                  89
                  92
                  99
                  71
                  73
                 100
                 107
                 106
                  77
                  81
                 110
                  78
                 115

                  71
                  73
                 100
                 107
                 106
                  77
                  81
                 110
                  78
                 115
                 117
                  84
                  82
                  83
                 119
                  86
                 126
                 125
                 130
                  94
                 131
                  93
                 136
                  91
                  96
                 138
                  97
                 142
                 146
                 148
                 149
                 151
                  98
                  95
                 141
 (60 rows)
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3329>
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