Ticket #207 (new bug report)

Opened 6 months ago

dijkstra_sp only works if pk is named gid

Reported by: zstauber Owned by: somebody
Priority: major Milestone:
Component: Dijkstra Version: 1.03
Keywords: dijkstra, dijkstra_sp, primary key, gid, ogc_fid Cc:


This is similar to ticket #206 concerning generalizing schema name, but in this case it is about generalizing the pk name. I can run "assign_vertex_id" on a table with any pk name, but when I run dikjstra_sp the pk must be named "gid" whereas the FWTools loader makes the pk "ogc_fid" by default. If I leave it as ogc_fid I get...

SELECT gid, AsText?(the_geom) AS the_geom FROM dijkstra_sp('tl_edges_test', 28932, 20953); ERROR: column "gid" does not exist LINE 1: SELECT gid,the_geom FROM shortest_path('SELECT gid as id, so...

QUERY: SELECT gid,the_geom FROM shortest_path('SELECT gid as id, source::integer, target::integer, length::double precision as cost FROM tl_edges_test', '28932' , '20953' , false, false), tl_edges_test where edge_id = gid CONTEXT: PL/pgSQL function "dijkstra_sp" line 12 at FOR over EXECUTE statement

Note: See TracTickets for help on using tickets.