Opened 14 years ago
Closed 14 years ago
#764 closed defect (fixed)
Topology: error using ST_AddIsoNode(..)
Reported by: | aperi2007 | Owned by: | strk |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 2.0.0 |
Component: | topology | Version: | master |
Keywords: | Cc: |
Description
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.
should be fixed at r6593