PROBLEM with pgrouting

[ichien86]

helo all, I get error when I use shortest_path_as_geometry_internal_id . the error message is ERROR : column referemce “edge_id” is ambiguous LINE 1 : …., FROM mytable’, ‘3’, ‘4’, false, false), mytable where edge_id=… Query : SELECT gid, the_geom. FROM shortest_path(‘select gid as id, source::integer, target:;integer, length::double precision as cost FROM mytable’, ‘3’, ‘4’. False, false), mytable where edge_id = id Context : PL/pgSQL function “shortest_path_as_geometry_internal_id” line 9 at for over execute statement Pl/pgSQL function “shortest_path_as_geometry” line 30 at for over select rows. Any ideas? Thanks at before

[ichien86]

helo all, I get error when I use shortest_path_as_geometry_internal_id . the error message is ERROR : column referemce “edge_id” is ambiguous LINE 1 : …., FROM mytable’, ‘3’, ‘4’, false, false), mytable where edge_id=… Query : SELECT gid, the_geom. FROM shortest_path(‘select gid as id, source::integer, target:;integer, length::double precision as cost FROM mytable’, ‘3’, ‘4’. False, false), mytable where edge_id = id Context : PL/pgSQL function “shortest_path_as_geometry_internal_id” line 9 at for over execute statement Pl/pgSQL function “shortest_path_as_geometry” line 30 at for over select rows. Any ideas? Thanks at before oh ya I use PostgreSQL 8.2.6 and pgrouting 1.0.0.a-0_win32

[anton]

Hi,

It is better to switch to the 1.0 version.

[anton]

No activity for last 2 months. Closed as fixed.