[postgis-devel] [PostGIS] #2007: topogeo_addlinestring: behaviour depends on query order (error - geometry intersects edge)

[PostGIS]

#2007: topogeo_addlinestring: behaviour depends on query order (error - geometry
intersects edge)
-------------------------------+--------------------------------------------
 Reporter:  amartin            |       Owner:  strk         
     Type:  defect             |      Status:  new          
 Priority:  medium             |   Milestone:  PostGIS 2.0.2
Component:  topology           |     Version:  2.0.x        
 Keywords:  linestring, order  |  
-------------------------------+--------------------------------------------

Comment(by strk):

 A way to compute the minimum distance between any two points:
 {{{
 with
  inp as ( select YOUR_GEOM_HERE as g ),
  d as ( select (st_dumppoints(g)).* from inp ),
  dist as (  select st_distance(a.geom,b.geom) as distance from d a, d b
  where b.path[1] > a.path[1] )
  select min(distance) from dist where distance > 0;
 }}}

 Maybe such function should be made available to simplify picking a
 tolerance for topologies.
 The TopoGeo_add* functions could refuse to run if the given tolerance is >
 the geometry possibility to hold it. But running on every attempt would
 degrade performance a lot, so probably better to do it outside...

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2007#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.