<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
dear pgrouting list, <br><br>i would like to ask a question regarding the darp branch of pgrouting. i am trying to get that up and running for windows 7 - which works fine using the compiled version of sanak (https://github.com/sanak). <br>nevertheles i am getting an error if i am using the darp function. I have prepared the data according to the documentation and the darp function starts working - indicated by the messages window of postgres: orders and vehicle are read in and processed correctly, but the distances query throws an error: <br><table class="CALSTABLE" border="1"><tbody><tr><td><tt class="LITERAL">42P11</tt></td>
<td>INVALID CURSOR DEFINITION</td>
<td>invalid_cursor_definition</td></tr></tbody></table><br>the complete messages output is given here: <br>HINWEIS: inside darp<br>HINWEIS: start darp<br>HINWEIS: Query: select order_id, size, pu_time, do_time, pu_lt, do_lt, pu_ut, do_ut, from_point, to_point from "order" order by order_id<br>HINWEIS: Query executed<br>HINWEIS: Orders before: 0<br>HINWEIS: cursor fetched<br>HINWEIS: Fetching order<br>HINWEIS: Tuples: 8<br>HINWEIS: Got tuple desc<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 1<br>HINWEIS: order_id = 1<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79694728<br>HINWEIS: to = 79694736<br>HINWEIS: size = 3.000000<br>HINWEIS: Order fetched<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 2<br>HINWEIS: order_id = 2<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79694992<br>HINWEIS: to = 79695000<br>HINWEIS: size = 4.000000<br>HINWEIS: Order fetched<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 3<br>HINWEIS: order_id = 3<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79695256<br>HINWEIS: to = 79695264<br>HINWEIS: size = 5.000000<br>HINWEIS: Order fetched<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 4<br>HINWEIS: order_id = 4<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79695520<br>HINWEIS: to = 79695528<br>HINWEIS: size = 2.000000<br>HINWEIS: Order fetched<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 5<br>HINWEIS: order_id = 5<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79695784<br>HINWEIS: to = 79695792<br>HINWEIS: size = 10.000000<br>HINWEIS: Order fetched<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 6<br>HINWEIS: order_id = 6<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79696048<br>HINWEIS: to = 79696056<br>HINWEIS: size = 3.000000<br>HINWEIS: Order fetched<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 7<br>HINWEIS: order_id = 7<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79696312<br>HINWEIS: to = 79696320<br>HINWEIS: size = 5.000000<br>HINWEIS: Order fetched<br>HINWEIS: inside fetch_order<br>HINWEIS: id = 8<br>HINWEIS: order_id = 8<br>HINWEIS: puTime = 386758800<br>HINWEIS: doTime = 386762400<br>HINWEIS: puLT = d<br>HINWEIS: doLT = d<br>HINWEIS: puUT = d<br>HINWEIS: doUT = d<br>HINWEIS: from = 79696576<br>HINWEIS: to = 79696584<br>HINWEIS: size = 0.000000<br>HINWEIS: Order fetched<br>HINWEIS: cursor fetched<br>HINWEIS: Tuples: 8<br>HINWEIS: order_num = 8<br>HINWEIS: Query: select id, id as vehicle_id, capacity, depot from vehicle<br>HINWEIS: Query executed<br>HINWEIS: Fetching order<br>HINWEIS: Tuples: 1<br>HINWEIS: Got tuple desc<br>HINWEIS: Before vehicle fetched<br>HINWEIS: inside fetch_vehicle<br>HINWEIS: id = 0<br>HINWEIS: Got vehicle_id<br>HINWEIS: vehicle_id = 1<br>HINWEIS: capacity = 15.000000<br>HINWEIS: Vehicle fetched<br>HINWEIS: Tuples: 1<br>HINWEIS: Query: select * from distances_5<br>HINWEIS: Query executed<br>HINWEIS: Fetching distance<br>HINWEIS: Got tuple desc<br>FEHLER: Plan mit mehreren Anfragen kann nicht als Cursor geöffnet werden<br><br>********** Error **********<br><br>FEHLER: Plan mit mehreren Anfragen kann nicht als Cursor geöffnet werden<br>SQL state: 42P11<br><br><br>I would be interested in the following things:<br>which output should the distances query have (from_order, to_order, from_point, to_point, value): i assume for every order_id (from_point) the distances to every other order_id (drop_off point) should be the desired output?<br><br>thanks very much in advance :)<br>johannes scholz<br><br> </div></body>
</html>