<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
fsalas wrote:
<blockquote cite="mid:015001c8f0f1$46df19f0$3fb09ea9@deltha" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi, </font></div>
<div> </div>
<div><font face="Arial" size="2">why when i try to excecute ths
sentece <span class="command">SELECT * FROM shortest_path('SELECT id,
source, target,x1,y1,x2,y2,cost,reverse_cost from
roads',26,39,true,true);</span><br>
</font></div>
<div><font face="Arial" size="2">appear this error </font></div>
<div> </div>
<div> </div>
<div><font face="Arial" size="2">
<div><img alt="" src="cid:part1.09080700.07060504@lrcwe.com"
align="bottom" border="0" hspace="0"></div>
</font></div>
<div> </div>
<div><font face="Arial" size="2">I follow the instruction on tutorial
<font size="3">PgRouting 1.02 on Win32</font></font></div>
</blockquote>
But you didn't do this step:<br>
<h3 class="title">4.1. Change to do for reverse_cost</h3>
<p>Here
before using our functions, we must take care of the value of field
reverse_cost. Indeed reverse_cost must take positive value else
PostgreSQL server crash! :(. We can take a expensive value.
reverse_cost=1000 should be enough in order to supporting one-way
streets.</p>
<pre class="programlisting">UPDATE roads SET reverse_cost=1000 WHERE oneway='Y';
</pre>
Restart your server and run the above sql command.<br>
<br>
Bruce<br>
<br>
<br>
</body>
</html>