Dear Nicol,
I guess in your input data there is a duplicate object, e.g. two lines
having the same source nad target id.
we've implemented a test-function into postgres, which shows thwese
errors. we want to give this
back to camp2camp soon, so that this function could be implemented into
the dijkstra module.
sorry, have to go soon, I send the sql for this function tomorrow,
till
Nicol Hermann schrieb:
Hi list,
i did my first steps with the pgdijkstra routing module distributed with
the cartoweb release 3.2.
I compiled the module against a 8.0.3 Postgresql database with the
following postgis configuration
"POSTGIS="1.1.0CVS" GEOS="2.1.3" PROJ="Rel. 4.4.9, 29 Oct 2004"
USE_STATS DBPROC="0.3.1" RELPROC="0.3.1""
I work through the readme document
(http://cartoweb.org/downloads/pgdijkstra/README.txt) and tried the
example in the sektion 'POSTGIS GEOMETRIES IMPORTATION'
The first step i did after the creation of the table with the given
multilinestrings was:
SELECT assign_vertex_id('routing', 0.1);
After that i execute the statement:
SELECT create_graph_tables('routing', 'int4');
and got the following error:
ERROR: duplicate key violates unique constraint
"routing_edges_source_key"
CONTEXT: SQL statement "INSERT INTO routing_edges (id, source, target)
VALUES (3, '3', '3')"
PL/pgSQL function "create_graph_tables" line 27 at execute statement
Any hints what i'am doing wrong?
many thanks
Nicol
_______________________________________________
Cartoweb-users mailing list
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users
--
******************************************
* released: AmeiN! ArcMap-Export-2-UMN *
* LiveLinux 'WebGIS on CD' *
* http://www.terrestris.de *
******************************************
------------------------------------------
Dipl. Geogr. Till Adams
terrestris, H. Paulsen& T. Adams GbR
Siemensstr. 8 * 53121 Bonn
Tel.: 0228 962 899 52 * Fax.: 0228 962 899 57
[EMAIL PROTECTED] * http://www.terrestris.de
_______________________________________________
Cartoweb-users mailing list
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users
