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: |
Description
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
