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

PostGIS trac at osgeo.org
Wed Apr 1 00:46:08 PDT 2026


#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 have installed this version on a new server and am currently running it
 on other problem areas where we miss results.

 When running CreateTopology with zero precision, I encountered the
 following error:


 {{{
 XX000: Side-location conflict: new edge starts in face 63 and ends in face
 6876

 }}}

 However, when I switch back to a precision of 1e‑07, it works correctly
 for that area. At the moment, the main focus is to get the correct
 results. I will do more comparative testing of these two versions later
 and report back.

 Regarding the comment about running with zero tolerance: one drawback is
 that it leaves a big cleanup work for the post jobs. This typically
 involves removing a significant number of extra edges, which is
 time‑consuming.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6062#comment:18>
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