0

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);
Jakub Kania
  • 2,814
  • 15
  • 20
GP92
  • 653
  • 3
  • 12
  • 22
  • 1
    Shooting star is pgrouting function so you should add the version of pgrouting. Also, please see: http://gis.stackexchange.com/questions/20793/is-shooting-star-broken-in-pgrouting-1-05 – Jakub Kania Apr 28 '13 at 10:53
  • @JakubKania The link for new binaries is broken. – GP92 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

0 Answers0