[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