***SPAM***[postgis-users] error with PgRouting 1.02 on Win32

Bruce Rindahl rindahl at lrcwe.com
Mon Jul 28 13:36:29 PDT 2008

fsalas wrote:
> Hi,
> why when i try to excecute ths sentece SELECT * FROM 
> shortest_path('SELECT id, source, target,x1,y1,x2,y2,cost,reverse_cost 
> from roads',26,39,true,true);
> appear this error
> I follow the instruction on tutorial PgRouting 1.02 on Win32
But you didn't do this step:

      4.1. Change to do for reverse_cost

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.

UPDATE roads SET reverse_cost=1000 WHERE oneway='Y';

Restart your server and run the above sql command.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080728/c8e72d9e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 15029 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080728/c8e72d9e/attachment.jpe>

More information about the postgis-users mailing list