Here are the steps i did:

  1. Added ppa to repository sources
  2. in synaptic marked all pgrouting for postgres 8.4
  3. apply (everything was ok)
  4. restarted postgres

But, i just tried a simple function shortest_path and it seems to do not recognise it:

ERROR: function shortest_path(text, integer, integer, boolean, boolean) does not exist LINE 1: SELECT * FROM shortest_path('

This is the query:

SELECT * FROM shortest_path('SELECT gid as id,source::integer as source,target::integer as target,length::double precision as cost FROM topologia'::text,1, 2, false, false);

Is there anything else that I'm missing?

1 Answer 1


I just found the solution.

After the steps above, one has to actually add the functions to the postgresql database:

$ sudo su postgres

$ psql -d routing -f /usr/share/postlbs/routing_core.sql

$ psql -d routing -f /usr/share/postlbs/routing_core_wrappers.sql

$ psql -d routing -f /usr/share/postlbs/routing_topology.sql


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.