[PostGIS] #6120: XX000: SQL/MM Spatial exception - curve not simple

[PostGIS]

#6120: XX000: SQL/MM Spatial exception - curve not simple
--------------------------------+---------------------------
  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 strk):

 Possibly useful workaround, when the desired effect is data cleanup, is
 simplifying the existing edge:

 {{{
 SELECT topology.ST_ChangeEdgeGeom(
   't6120',
    edge_id,
    ST_Simplify(geom, 1e-14)
 )
 FROM t6120.edge;
 }}}

 Note that a simplification tolerance of 1e-15 is not enough, even if it
 does remove 1 vertex from the original 6 vertices of the edge. Tolerance
 of 1e-14 drops two of those vertices.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6120#comment:4>
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.