[Cartoweb-users] create_graph_tables error...

[Bruno Maluche Neto]

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" <sylvain.pasche at camptocamp.com>
To: "Bruno Maluche Neto" <maluche at labtrans.ufsc.br>
Cc: <cartoweb-users at lists.maptools.org>
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
>> Cartoweb-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>