pgRouting

Ticket #93 (closed bug report: fixed)

Opened 8 months ago

Last modified 6 months ago

PROBLEM with pgrouting

Reported by: ichien86 Assigned to: anton
Priority: major Milestone:
Component: A* Version: 1.0
Keywords: edge_id is ambiguous Cc:

Description

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

Change History

01/29/08 08:54:23 changed by 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

01/29/08 09:44:19 changed by anton

  • owner changed from somebody to anton.
  • status changed from new to assigned.

Hi,

It is better to switch to the 1.0 version.

03/27/08 14:41:00 changed by anton

  • status changed from assigned to closed.
  • resolution set to fixed.

No activity for last 2 months. Closed as fixed.