[postgis-devel] [PostGIS] #764: Topology: error using ST_AddIsoNode(..)

[PostGIS]

#764: Topology: error using ST_AddIsoNode(..)
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  strk         
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  topology   |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------
 Hi,

 I'm testing the topology using postgres 9.0.2 on windows with postgis
 2.0.0 trunk compiled from Robe 10/Jan/2011.

 Try-ing this code sql:

 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 nodes
 --
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(1
 4)'));
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(2
 2)'));
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(4
 4)'));
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(6
 6)'));
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(6
 9)'));
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(10
 3)'));
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(10
 9)'));
 select
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(12
 1)'));

 -----

 I have this error:

 ERROR: function st_intersects(geometry, unknown) is not unique
   Hints: Could not choose a best candidate function. You might need to add
 explicit type casts.
   Dove: PL/pgSQL function "st_addisonode" line 45 at ciclo FOR su una
 istruzione EXECUTE
  Riga: 1

 Regards,

 Andrea.

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