[Cartoweb-users] create_graph_tables error...

Bruno Maluche Neto maluche at labtrans.ufsc.br
Mon Dec 19 14:05:53 EST 2005


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20051219/7efe1a02/attachment.html


More information about the Cartoweb-users mailing list