Skip to main content
deleted 28 characters in body; edited tags; edited title
Source Link
PolyGeo
  • 65.5k
  • 29
  • 115
  • 353

Installing pgRouting on Ubuntu Lucid?

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);

It should be simple...Is there anything else that I'm missing?

Cheers, Marco

Installing pgRouting Ubuntu Lucid

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);

It should be simple... anything else that I'm missing?

Cheers, Marco

Installing pgRouting on Ubuntu Lucid?

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?

Tweeted twitter.com/#!/StackGIS/status/53064007510261760
deleted 6 characters in body
Source Link

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_idsource,target::integer as target_idtarget,length::double precision as cost FROM topologia'::text,1, 2, false, false);

It should be simple... anything else that I'm missing?

Cheers, Marco

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_id,target::integer as target_id,length::double precision as cost FROM topologia'::text,1, 2, false, false);

It should be simple... anything else that I'm missing?

Cheers, Marco

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);

It should be simple... anything else that I'm missing?

Cheers, Marco

added 200 characters in body; added 19 characters in body
Source Link

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(unknowntext, 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_id,target::integer as target_id,length::double precision as cost FROM topologia'::text,1, 2, false, false);

It should be simple... anything else that I'm missing?

Cheers, Marco

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(unknown, integer, integer, boolean, boolean) does not exist LINE 1: SELECT * FROM shortest_path('

It should be simple... anything else that I'm missing?

Cheers, Marco

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_id,target::integer as target_id,length::double precision as cost FROM topologia'::text,1, 2, false, false);

It should be simple... anything else that I'm missing?

Cheers, Marco

Source Link
Loading