[Cartoweb-users] create_graph_tables error...

[Sylvain Pasche]

Maybe it is a bug.

Please open a bug report, and tell us a maximum of information so that
the issue is reproducible (data example, sql snippet, ...).

See this for information how to do a good bug report:
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html

Regards,

Sylvain

Le mardi 20 décembre 2005 à 10:23 -0200, Bruno Maluche Neto a écrit :
> 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
> > 
>