[postgis-tickets] [PostGIS] #2273: TopoGeo_AddPolygon returns more polygons second call

PostGIS trac at osgeo.org
Sat Feb 5 02:51:42 PST 2022


#2273: TopoGeo_AddPolygon returns more polygons second call
-----------------------+-----------------------------
  Reporter:  robe      |      Owner:  strk
      Type:  defect    |     Status:  closed
  Priority:  medium    |  Milestone:  PostGIS Fund Me
 Component:  topology  |    Version:  master
Resolution:  invalid   |   Keywords:
-----------------------+-----------------------------
Changes (by strk):

 * status:  new => closed
 * resolution:   => invalid


Comment:

 I've tried this testcase with current PostGIS version.
 First run returns 455 rows (which are *faces*) second run returns 614 rows
 (as all subsequent ones).

 Thinking a bit about it I'm not fully surprised, because when a
 TopoGeometry is initially created may be composed by a single face but
 upon creating *more* TopoGeometry (subsequent records) the single face may
 be split into more faces, which is why by the end of the load statement
 there would be more faces for polygons.

 You can see this by querying the number of faces at the end of the first
 load, without re-loading the data:

 {{{
 SELECT gid, TopoGeo_AddPolygon('test_chennai', geom) As face_id FROM
 test_wet; -- returns 455 rows
 SELECT count(*) FROM test_chennai.face where face_id > 0; -- returns 636
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2273#comment:6>
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