[pgrouting-users] Error in "dijkstra_sp_delta_directed" line 83

[Daniel Kastl]

Hi Mathias,

Could you post the query?
The pgRouting function you're using is this one:
https://github.com/pgRouting/pgrouting/blob/master/core/sql/routing_core_wrappers.sql#L594

Can you check if the expected parameters have the right data types?
If the data type is not correct it sometimes is enough to type cast.

Daniel


On Thu, Jun 21, 2012 at 9:57 AM, Mathias Villeger <
mathias.villeger at gmail.com> wrote:

> Hello,
>
> I get the following error using the dijkstra_sp_delta function :
>
> type of parameter 33 (integer) does not match that when preparing the plan
> (numeric)
>   Où : PL/pgSQL function "dijkstra_sp_delta_directed" line 83 at assignment
> PL/pgSQL function "dijkstra_sp_delta" line 19 at FOR over EXECUTE statement
>
> I didn't find anything about that.
> 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.
> The error occurs randomly : A failing request can work at its next call.
>
> Versions :
> Postgres 9.1
> Postgis 1.5
> Pgrouting 1.0.5
>
> Any idea about this?
>
> Regards,
>
> Mathias.
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120621/0e042acd/attachment.html>