[PostGIS] #6129: Missing area with topology.ST_GetFaceGeometry('arstat_2026_overlay_02_348',101383), but alle edges seems to be prensent

[PostGIS]

#6129: Missing area with
topology.ST_GetFaceGeometry('arstat_2026_overlay_02_348',101383), but alle
edges seems to be prensent
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.6.5
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 Replying to [comment:3 strk]:
 > I've imported all the edges from your sql into a new topology, and
 verified I got no drift (I had to order by edge_id descending or I was
 getting an additional snap otherwise, despite tolerance=0). This is how I
 did it:
 > {{{
 > select createtopology('t6129', 4258);
 > select topogeo_addlinestring('t6129', geom, 0) from edges_face_101383
 order by edge_id desc;
 > }}}
 >
 > This is how I verified all edges in the resulting topology had an equal
 edge in the source set:
 > {{{
 > select e.edge_id from t6129.edge e where not exists ( select * from
 edges_face_101383 o where o.geom = e.geom ); -- 0 rows returned, OK
 > select e.edge_id from t6129.edge  e where not exists ( select * from
 t6129.edge o where o.geom = e.geom ); -- o rows returned, OK
 > }}}
 >
 > The resulting topology is reported to be valid (no rows from `SELECT
 ValidateTopology`)
 > I'm attaching the pgtopo_export of it.

 It seem like problem is related from going from zero tolerance to 1e-07
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6129#comment:5>
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.