Hi Daniel,<br><br>I added type casts to request parameters but the error persists :<br>SELECT gid, the_geom FROM dijkstra_sp_delta( CAST( 'routes' AS varchar ), CAST( :source AS int4 ), CAST( :target AS int4 ), CAST( :delta AS float8 ) );<br>
<br>I solved it changing this bloc of function dijkstra_sp_delta_directed : <br><br><b>FOR rec IN EXECUTE 'SELECT CASE WHEN '||source_x||'<'||target_x||<br> ' THEN '||source_x||' ELSE '||target_x||<br>
' END as ll_x, CASE WHEN '||source_x||'>'||target_x||<br> ' THEN '||source_x||' ELSE '||target_x||' END as ur_x'<br> LOOP<br>END LOOP;<br><br>ll_x := rec.ll_x;<br>
ur_x := rec.ur_x;<br><br>FOR rec IN EXECUTE 'SELECT CASE WHEN '||source_y||'<'||<br> target_y||' THEN '||source_y||' ELSE '||<br> target_y||' END as ll_y, CASE WHEN '||<br>
source_y||'>'||target_y||' THEN '||<br> source_y||' ELSE '||target_y||' END as ur_y'<br> LOOP<br>END LOOP;</b><br><br>with bloc :<br><br><br><b> # Cast in Float to prevent plan error in PostgreSQL<br>
FOR rec IN EXECUTE 'SELECT CASE WHEN CAST('||source_x||' as float8)< CAST('||target_x||<br> ' as float8) THEN CAST('||source_x||' as float8) ELSE CAST('||target_x||<br> ' as float8) END as ll_x, CASE WHEN CAST('||source_x||' as float8)>CAST('||target_x||<br>
' as float8) THEN CAST('||source_x||' as float8) ELSE CAST('||target_x||' as float8) END as ur_x'<br> LOOP<br> END LOOP;<br><br> ll_x := rec.ll_x;<br> ur_x := rec.ur_x;<br>
<br> # Cast in Float to prevent plan error in PostgreSQL<br> FOR rec IN EXECUTE 'SELECT CASE WHEN CAST('||source_y||' as float8)<CAST('||<br> target_y||' as float8) THEN CAST('||source_y||' as float8) ELSE CAST('||<br>
target_y||' as float8) END as ll_y, CASE WHEN CAST('||<br> source_y||' as float8)>CAST('||target_y||' as float8) THEN CAST('||<br> source_y||' as float8) ELSE CAST('||target_y||' as float8) END as ur_y'<br>
LOOP<br> END LOOP;</b><br><br>The error occured when source_x has not any decimal.<br>Should I create an issue on issue tracker?<br><br>Mathias.<br><br><br><div class="gmail_quote">2012/6/21 Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span><br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Mathias,<div><br></div><div>Could you post the query?</div><div>The pgRouting function you're using is this one:</div>
<div><a href="https://github.com/pgRouting/pgrouting/blob/master/core/sql/routing_core_wrappers.sql#L594" target="_blank">https://github.com/pgRouting/pgrouting/blob/master/core/sql/routing_core_wrappers.sql#L594</a></div>
<div><br></div><div>Can you check if the expected parameters have the right data types?</div><div>If the data type is not correct it sometimes is enough to type cast.</div><div><br></div><div>Daniel</div><div><br><br><div class="gmail_quote">
<div><div class="h5">
On Thu, Jun 21, 2012 at 9:57 AM, Mathias Villeger <span dir="ltr"><<a href="mailto:mathias.villeger@gmail.com" target="_blank">mathias.villeger@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div><div class="h5">
Hello,<br>
<br>
I get the following error using the dijkstra_sp_delta function :<br>
<br>
type of parameter 33 (integer) does not match that when preparing the plan (numeric)<br>
Où : PL/pgSQL function "dijkstra_sp_delta_directed" line 83 at assignment<br>
PL/pgSQL function "dijkstra_sp_delta" line 19 at FOR over EXECUTE statement<br>
<br>
I didn't find anything about that.<br>
I'm using postgis with a java application. Calls are done with
Hibernate's named queries, but I don't think that the use of Hibernate
is the cause of this error.<br>
The error occurs randomly : A failing request can work at its next call.<br>
<br>
Versions :<br>
Postgres 9.1<br>
Postgis 1.5<br>
Pgrouting 1.0.5<br>
<br>
Any idea about this?<br>
<br>
Regards,<br>
<br>
Mathias.
<br></div></div>_______________________________________________<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><br>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><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>
</font></span></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>