[Cartoweb-users] pgdijkstra error

Sylvain Pasche sylvain.pasche at camptocamp.com
Thu Jun 22 09:00:24 EDT 2006


Hi Nicol,

You've encountered a known bug of pgdijkstra. You can find some more
information and possible solutions on the bug page:

http://bugzilla.maptools.org/show_bug.cgi?id=1180

Regards,

Sylvain

Le jeudi 22 juin 2006 à 14:54 +0200, Nicol Hermann a écrit :
> 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
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users



More information about the Cartoweb-users mailing list