[Cartoweb-users] pgdijkstra error

[Till Adams]

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
>Cartoweb-users at lists.maptools.org
>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
info at terrestris.de * http://www.terrestris.de