[Cartoweb-users] pgdijkstra error

Nicol Hermann mapserver at geoworld.de
Thu Jun 22 08:54:19 EDT 2006


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



More information about the Cartoweb-users mailing list