[PostGIS] #6062: More error XX000: SQL/MM Spatial exception - geometry

[PostGIS]

#6062: More error   XX000: SQL/MM Spatial exception - geometry
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.6.2
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 I’ve tested this with different tolerance values and it works in some
 areas but fails in others.

 On the master PostGIS we now have very few errors, and this week I
 switched to minimum tolerance, since that seems both more stable and
 faster.

 As you also pointed out, using a TopoSnap function is a much safer
 approach. The caller can decide when to trigger it, choose the parameters,
 and do retry to add line.

 This also lets me log problem geometries to a table, which makes it much
 easier to check the results afterwards and not cover up problem lines.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6062#comment:13>
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.