<HTML><BODY><p>Hi Stephen,<br><br>I added new issue about a <span class="js-issue-title">couple of bugs pgr_createTopology</span>:<br><a href="https://github.com/pgRouting/pgrouting/issues/240" data-mce-href="https://github.com/pgRouting/pgrouting/issues/240">https://github.com/pgRouting/pgrouting/issues/240</a><br>Thanks very much for you efforts.<br><br>Best regards.<br>
</p><p><br data-mce-bogus="1"></p><p><br data-mce-bogus="1"></p><blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">
<div id="">
<div class="js-helper js-readmsg-msg">
<style type="text/css"></style>
<div id="style_13942025090000000253" class="mr_read__body">
<base target="_self" href="https://e.mail.ru/">
<div id="style_13942025090000000253_BODY">Hi Vladimir,<br>
<br>
This is a good catch!<br>
<br>
Can you please write a bug on this issue so we remember to resolve it in <br>
the next release.<br>
<br>
Glad you got this working.<br>
<br>
Thanks,<br>
-Steve<br>
<br>
On 3/7/2014 5:45 AM, Vladimir wrote:<br>
> Hi again.<br>
><br>
> As written in the documentation<br>
> <<a href="http://docs.pgrouting.org/2.0/en/src/trsp/doc/index.html#trsp>for" target="_blank">http://docs.pgrouting.org/2.0/en/src/trsp/doc/index.html#trsp>for</a> SQL<br>
> statement of TRSP:<br>
> id: int4 identifier of the edge<br>
><br>
> But pgr_createTopology function creates new "noded" table with "id" of<br>
> bigint type.<br>
><br>
> I've solved this problem by casting "id" to integer type.<br>
><br>
> Now that's works:<br>
> SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_trsp('SELECT<br>
> id::integer,source::integer,target::integer,cost::float FROM edge_tab',<br>
> 138, 0.5, 161, 0.5, false, false);<br>
><br>
> Thanks very much to author of this<br>
> <<a href="http://pgrouting-users.974093.n3.nabble.com/pgrouting-users-Shortest-Path-TRSP-td3782221.html" target="_blank">http://pgrouting-users.974093.n3.nabble.com/pgrouting-users-Shortest-Path-TRSP-td3782221.html</a>><br>
> post for idea.<br>
><br>
> Best regards.<br>
><br>
><br>
> Hello All!<br>
><br>
> I try to use TRSP with source_edge/target_edge syntax:<br>
><br>
> SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_trsp('SELECT<br>
> id,source::integer,target::integer,cost::float FROM edge_tab', 138,<br>
> 0.5, 161, 0.5, false, false);<br>
><br>
> but the error "Start id was not found" occurs.<br>
><br>
> Edges with ids 138 and 161 exists in edge_tab that's checked by<br>
> SELECT * FROM edge_tab WHERE id in (138,161)<br>
><br>
> pgr_version: 2.0.0,pgrouting-2.0.0,0,f26831f,master,1.53.0<br>
><br>
> Please could you tell me what's wrong ?<br>
><br>
><br>
><br>
> _______________________________________________<br>
> Pgrouting-users mailing list<br>
> <a href="/compose?To=Pgrouting%2dusers@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
> <<a href="/compose?To=%2fcompose%3fTo%3dPgrouting%252dusers@lists.osgeo.org">/compose?To=Pgrouting%2dusers@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>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Pgrouting-users mailing list<br>
> <a href="/compose?To=Pgrouting%2dusers@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>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="/compose?To=Pgrouting%2dusers@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>
</div>
<base target="_self" href="https://e.mail.ru/">
</div>
</div>
</div>
</blockquote>
<br></BODY></HTML>