Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server

SELECT * FROM shortest_path_shooting_star('
   SELECT gid AS id, 
      start_id::int4 AS source, 
      end_id::int4 AS target, 
      shape_leng::float8 AS cost,
      x1, y1, x2, y2,
      rule, to_cost
   FROM viz_network',
   173,
   97,
   false,
   false);

And digkstra algorithm is working fine :

SELECT * FROM shortest_path('
  SELECT gid AS id, 
      start_id::int4 AS source, 
      end_id::int4 AS target, 
      shape_leng::float8 AS cost
  FROM viz_network',
  1,
  310,
  false,
  false);
share|improve this question
1  
Shooting star is pgrouting function so you should add the version of pgrouting. Also, please see: gis.stackexchange.com/questions/20793/… –  Jakub Kania Apr 28 '13 at 10:53
    
@JakubKania The link for new binaries is broken. –  Jeevan Patnaik Apr 28 '13 at 11:07
    
Well, you'd have to ask @sanak about it then. But he wrote he will update the official builds and you still haven't wrote what version of pgrouting you're using, is it the latest one? –  Jakub Kania Apr 28 '13 at 11:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.