[pgrouting-users] Function shortest_path does not exist

Yasir Shoaib yasirshoa at gmail.com
Thu Jul 29 14:05:31 EDT 2010


Hello Frank,

You need to login to your pgrouting db instead of postgres db.
Try this from terminal and then running the query:
   psql -d <pgrouting_db> -U <user>

Yasir

On 29 July 2010 12:32, Salet Frank <frank.salet at localyse.nl> wrote:

>  Hey everybody,
>
>
>
> Sorry for disturbing you but I’m a little bit lost in one simple and
> probably easy to solve issue but I can’t see it anymore. What is wrong with
> this request? Why is the inner-query treated as unknown instead of text?
> Thank you!
>
>
>
> postgres=# SELECT * FROM shortest_path('SELECT gid as id, source::integer,
> target::integer, length::double precision as cost FROM ways',10, 20, false,
> false);
>
> ERROR:  function shortest_path(unknown, integer, integer, boolean, boolean)
> does not exist
>
> LINE 1: SELECT * FROM shortest_path('SELECT gid as id, source::integ...
>
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
>
>
>
> The function does exist because I executed:
>
> CREATE OR REPLACE FUNCTION shortest_path(sql text, source_id integer,
> target_id integer, directed boolean, has_reverse_cost boolean)
>   RETURNS SETOF path_result AS
> '/usr/lib/postgresql/8.4/lib/librouting', 'shortest_path'
>   LANGUAGE 'c' IMMUTABLE STRICT
>   COST 1
>   ROWS 1000;
> ALTER FUNCTION shortest_path(text, integer, integer, boolean, boolean)
> OWNER TO postgres;
>
>
>
> Regards
>
> Frank
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20100729/8c20effe/attachment.html


More information about the Pgrouting-users mailing list