[postgis-users] ERROR CREATING TOPOLOGY

[Phil James]

I was trying to get topology working on 2.0 Alpha6 (on 9.1 on Windows). Dated 22/02/12 from http://postgis.refractions.net/download/windows/experimental.php (r9269)

I tried to create topology on existing OSM data but that failed with Error point not on edge.

I then created a simple file with 3 lines and imported that into postgis.  The lines intersect but do not self intersect.

This fails with the same error.  

SELECT topology.DropTopology('test_topo');
SELECT CreateTopology('test_topo', find_srid('public', 'makeline', 'geom'));
SELECT AddTopoGeometryColumn('test_topo', 'public','makeline', 'topogeom', 'LINE');
UPDATE makeline SET topogeom = toTopoGeom(geom, 'test_topo', 1);

And I get the same errors.  Any ideas what I am doing wrong or is this a bug?



ERROR: SQL/MM Spatial exception - point not on edge
SQL state: P0001
Context: PL/pgSQL function "topogeo_addpoint" line 66 at assignment
PL/pgSQL function "topogeo_addlinestring" line 111 at assignment
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);"
PL/pgSQL function "totopogeom" line 116 at EXECUTE statement

The shapefile is attached.

Many thanks

Phil
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120228/78a3cafc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: makeline.zip
Type: application/zip
Size: 1208 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120228/78a3cafc/attachment.zip>