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:[EMAIL PROTECTED] http://www.agi.so.ch
dijkstra.sql
Description: Binary data
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users