Thanks.
Now I executed :
select update_cost_from_distance('roads')
But all rows was update with the same COST... Why that?----- Original Message ----- From: "Sylvain Pasche" <[EMAIL PROTECTED]>
To: "Bruno Maluche Neto" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Tuesday, December 20, 2005 7:18 AM Subject: Re: [Cartoweb-users] create_graph_tables error...
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 [email protected] http://lists.maptools.org/mailman/listinfo/cartoweb-users
_______________________________________________ Cartoweb-users mailing list [email protected] http://lists.maptools.org/mailman/listinfo/cartoweb-users
