[Cartoweb-users] create_graph_tables error...

[Sylvain Pasche]

Hello,

You have this error because your graph data contains duplicate (source,
target) entries which is not supported actually.

This is a known problem that should be addressed, you can have a look at
the enhancement request opened, which gives a workaround for this issue:

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

Regards,

Sylvain

Le lundi 19 décembre 2005 à 17:05 -0200, Bruno Maluche Neto a écrit :
> Hi all...
> I have a road table (MULTILINESTRING), so I created a
> source_id,target_id and edge_id on IT...
> Then I executed 
> - > select assign_vertex_id('roads',0.1)
> So, my source_id and target_id was filled OK...
>  
> Then I executed:
> select create_graph_tables('roads' , 'int4');
> than I got the following error:
> 
> ERROR:  duplicate key violates unique constraint
> "rodovia_pavimentada_edges_source_key"
> CONTEXT:  SQL statement "INSERT INTO roads (id, source, target) VALUES
> (16, '17', '17')"
> PL/pgSQL function "create_graph_tables" line 27 at execute statement
>  
> Whats happened??
>  
> Ty
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users