<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I have used pgrouting on Windows 7 so I think this should work (everything else installed via stackbuilder)<div><br></div><div>What do you get for this query?</div><div><br></div><div>select * from ways where source = 24154 or target = 24157</div><div><br></div><div><br></div><div>charles</div><div><br><div><div>On Sep 13, 2011, at 8:37 AM, Daniel Kastl wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi Ali,<div><br></div><div>I may be wrong, and if there are Windows users out there who know it better, please correct me.</div><div>But the binaries for pgRouting were not compiled with Windows 7. They might work, but not necessarily.</div>
<div><br></div><div>Daniel</div><div><br><br><div class="gmail_quote">On Tue, Sep 13, 2011 at 2:39 AM, Ali Taha <span dir="ltr"><<a href="mailto:ali.taha@ritaj.ps">ali.taha@ritaj.ps</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Dear Daniel,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">I downloaded them from </span><a href="http://www.pgrouting.org/download.html" target="_blank">http://www.pgrouting.org/download.html</a> <span style="font-size:11.0pt;color:#1F497D"> (windows binaries section pgRouting-1.03_pg-8.4.2)<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">I have windows 7 OS<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal">
<span style="font-size:11.0pt;color:#1F497D">Thanks<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> <a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Daniel Kastl<br>
<b>Sent:</b> Tuesday, September 13, 2011 6:34 AM<br><b>To:</b> pgRouting users mailing list<br><b>Subject:</b> Re: [pgrouting-users] pgrouting installation<u></u><u></u></span></p><div><div></div><div class="h5"><p class="MsoNormal">
<u></u> <u></u></p><p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p><div><p class="MsoNormal">On Mon, Sep 12, 2011 at 11:20 AM, Ali Taha <<a href="mailto:ali.taha@ritaj.ps" target="_blank">ali.taha@ritaj.ps</a>> wrote:<u></u><u></u></p>
<div><div><p class="MsoNormal">Dear All,<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">I am trying to setup and test pgrouting, I followed the setups but it is still not working. If ollowed the following steps:<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p>1-<span style="font-size:7.0pt"> </span>Copay pgrouting libraries to ..\pgsql\8.4\lib<u></u><u></u></p></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">
>From where did you copy them?<u></u><u></u></p></div><div><p class="MsoNormal">Did you compile? Which OS?<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Daniel<u></u><u></u></p>
</div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><blockquote style="border-top-style: none; border-right-style: none; border-bottom-style: none; border-width: initial; border-color: initial; border-left-style: solid; border-left-color: rgb(204, 204, 204); border-left-width: 1pt; padding-top: 0in; padding-right: 0in; padding-bottom: 0in; padding-left: 6pt; margin-left: 4.8pt; margin-right: 0in; position: static; z-index: auto; ">
<div><div><p>2-<span style="font-size:7.0pt"> </span>Execute routing_core.sql and routing_core_wrappers.sql<u></u><u></u></p><p>3-<span style="font-size:7.0pt"> </span>Create a newtwork:<u></u><u></u></p><p style="margin-left:1.0in">
a.<span style="font-size:7.0pt"> </span>Added source and target fields<u></u><u></u></p><p style="margin-left:1.0in">b.<span style="font-size:7.0pt"> </span>Execute Execute <span style="color:#333333;background:white">assign_vertex_</span>id('<table>', float tolerance, '<geometry column', '<gid>')<u></u><u></u></p><p style="margin-left:1.0in">c.<span style="font-size:7.0pt"> </span>Added indices <u></u><u></u></p><p style="margin-left:1.0in">d.<span style="font-size:7.0pt"> </span>Added reverse_cost column.<u></u><u></u></p><p class="MsoNormal">Then I used the following query to retrieve records:<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">SELECT * FROM shortest_path(‘<u></u><u></u></p><p class="MsoNormal">
SELECT gid as id,<u></u><u></u></p><p class="MsoNormal">source::integer,<u></u><u></u></p><p class="MsoNormal">target::integer,<u></u><u></u></p><p class="MsoNormal">length::double precision as cost<u></u><u></u></p><p class="MsoNormal">FROM ways’,<u></u><u></u></p><p class="MsoNormal">24154,<u></u><u></u></p><p class="MsoNormal">24157,<u></u><u></u></p><p class="MsoNormal">false, false)<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">the query executes without errors, but return no data. I checked the table and the records seems OK. <u></u><u></u></p><p class="MsoNormal">is there a way to validate the database and verify the topology? How to make sure that the pgrouting library (dlls) are installed and working correctly?<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Thanks<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p></div></div><p class="MsoNormal" style="margin-bottom:12.0pt">
<br>_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><u></u><u></u></p>
</blockquote></div><p class="MsoNormal"><br><br clear="all"><u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal">-- <br><span style="font-size:10.0pt">Georepublic UG & Georepublic Japan<br>
eMail: <a href="mailto:daniel.kastl@georepublic.de" target="_blank"><span style="color:#4263AB">daniel.kastl@georepublic.de</span></a><br>Web: <a href="http://georepublic.de/" target="_blank"><span style="color:#4263AB">http://georepublic.de</span></a></span><u></u><u></u></p>
</div></div></div></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>
</div>
_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/pgrouting-users<br></blockquote></div><br></div></body></html>