I believe there is ID miss up.
If you run sample data step by step, there
are 3 tables roads, roads_edges,
and roads_ vertices.
In table roads, souce_id
and target_id are different with roads_edges.
But the two ids (same node, but it has two different ID in table roads and roads_edges) are connected by table roads_ vertices. In roads_ vertices,
id is the source/target used in roads-edges, and gid
is the id of same node used in tables roads.
Shortest_path asks for id from roads_edges. What you
passed are node ID from Table roads. It is why program
cannot find the path.
Fay
-----Original Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Eggenschwiler Raphael
Sent: Tuesday, January 10, 2006 9:10 AM
To:
[email protected]
Subject: [Cartoweb-users] dijkstra
Hi everyone !
I try to use this pgdijkstra on my data with :
SELECT arc_num_nod_src as
"source",arc_num as "id",arc_num_nod_des as
"target",arc_cost as "cost" FROM TAB_ARC;
source id target cost
0 6259
4769 0
4769 6260 4770 0
4770 6261 4771 0
4771 6262 4772 0
4772 6263 4773 0
0 6264
4775 0
4775 6265 4776 0
4776 6266 4777 0
4777 6267 4778 0
4778 6268 4779 0
4779 6269 4780 0
4780 6270 4781 0
0 6271
4783 0
4783 6272 4784 0
4784 6273 4785 0
4785 6274 4786 0
4786 6275 4787 0
4787 6276 4788 0
4788 6277 4789 0
4789 6278 4790 0
0 6279
4792 0
4792 6280 4793 0
But when I try this one :
select * from shortest_path('SELECT
arc_num_nod_src as "source",arc_num as "id",arc_num_nod_des
as "target",arc_cost as "cost" FROM
TAB_ARC',4769,4770,false,false);
I become this message :
ERROR: Error computing path: Source vertex not found
Can someone help me ??
