[postgis-devel] [PostGIS] #765: Topology: error adding two edge with a common node

[PostGIS]

#765: Topology: error adding two edge with a common node
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  strk         
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  topology   |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------
 Hi, try-ing to add two node with a common edge I'm having an error.

 In effect I'm not 100% sure this is a bug of topology or a bug of my sql
 code :)

 This is the code I try.

 ---
 DROP TABLE IF EXISTS CARICAMENTO.TEST;
 CREATE TABLE CARICAMENTO.TEST(ID INTEGER PRIMARY KEY, CODICE TEXT);
 SELECT topology.DropTopology('schema_topo');
 SELECT topology.CreateTopology('schema_topo',3003, 0.00005);
 SELECT topology.AddTopoGeometryColumn('schema_topo', 'caricamento',
 'test', 'topo_line', 'LINE');
 --
 -- insert all edges
 --
 select topology.ST_AddIsoEdge(
     'schema_topo',
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(1
 4)')),
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(2
 2)')),
     ST_GeomFromEWKT('SRID=3003;LINESTRING(1 4, 2 2)')
 );

 select topology.ST_AddIsoEdge(
     'schema_topo',
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(2
 2)')),
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(4
 4)')),
     ST_GeomFromEWKT('SRID=3003;LINESTRING(2 2, 4 4)')
 );

 ----
 And this is the error I see

 ERROR: SQL/MM Spatial exception - coincident node

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/765>
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.