<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; ">I was trying to get topology working on 2.0 Alpha6 (on 9.1 on Windows). Dated 22/02/12 from <a href="http://postgis.refractions.net/download/windows/experimental.php">http://postgis.refractions.net/download/windows/experimental.php</a> (<b style="color: rgb(85, 85, 85); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px; text-align: left; ">r9269)</b></div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; "><br></div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; ">I tried to create topology on existing OSM data but that failed with Error point not on edge.</div><div
style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; "><br></div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; ">I then created a simple file with 3 lines and imported that into postgis. The lines intersect but do not self intersect.</div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; "><br></div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; ">This fails with the same error. </div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; "><br></div><div><div><font face="'Courier New', courier, monaco, monospace, sans-serif">SELECT topology.DropTopology('test_topo');</font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif">SELECT CreateTopology('test_topo', find_srid('public', 'makeline',
'geom'));</font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif">SELECT AddTopoGeometryColumn('test_topo', 'public','makeline', 'topogeom', 'LINE');</font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif">UPDATE makeline SET topogeom = toTopoGeom(geom, 'test_topo', 1);</font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif"><br></font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif">And I get the same errors. Any ideas what I am doing wrong or is this a bug?</font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif"><br></font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif"><div><br></div><div>ERROR: SQL/MM Spatial exception - point not on edge</div><div>SQL state: P0001</div><div>Context: PL/pgSQL function "topogeo_addpoint" line 66 at assignment</div><div>PL/pgSQL function
"topogeo_addlinestring" line 111 at assignment</div><div>SQL statement "INSERT INTO test_topo.relation(topogeo_id, layer_id, element_type, element_id) SELECT 2, 1, 2, topogeo_addLineString('test_topo', '0102000020346C000002000000A145B607E0371441E04F8DF5012E2341643BDF93D05D1441BF9F1A75ED642241'::geometry, 0);"</div><div>PL/pgSQL function "totopogeom" line 116 at EXECUTE statement</div></font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif"><br></font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif">The shapefile is attached.</font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif"><br></font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif">Many thanks</font></div><div><font face="'Courier New', courier, monaco, monospace, sans-serif"><br></font></div><div><font face="'Courier New', courier, monaco, monospace,
sans-serif">Phil</font></div></div></div></body></html>