[postgis-users] PgRouting schema qualified tables etc.

[Düster Horst]

Hi 
 
I played a little bit with pgrouting to build a routing plugin client for QGIS. In principle it works fine but I found out some annoyances: 
 
1. The functions like shortest_path, dijkstra etc. don't respect schema qualified tables. 
2. always it is supposed and hard coded that GID is the primary key column of the table. 
3. always it is supposed and hard coded that the_geom is the column name of the geometry column. 
 
I have attached a modified version of the dijkstra_sp function to make this function more generic. 
 
Perhaps you can modify all other dependencies of the pgRouting functions in this way. 
 
Regards 
Horst 
 
  
 
 
 
------------------------------------------------ 
 
Dr. Horst Düster 
GIS-Koordinator, Stv. Amtschef 
 
Kanton Solothurn 
Bau- und Justizdepartement 
Amt für Geoinformation 
SO!GIS Koordination 
Rötistrasse 4 
CH-4501 Solothurn 
 
Telefon ++41(0)32 627 25 32 
Telefax ++41(0)32 627 22 14 
 
mailto:horst.duester at bd.so.ch 
http://www.agi.so.ch
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dijkstra.sql
Type: application/octet-stream
Size: 2141 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081211/e7a2ce64/attachment.obj>