[postgis-users] PgRouting schema qualified tables etc.

Daniel Kastl orkney at gmx.de
Thu Dec 11 02:44:36 PST 2008


Oh, good point!
... and I already thought this questions sounds familiar.
Thank you for the hint.

Daniel

Pedro Doria Meunier schrieb:
> Hi,
>
> Please see:
> http://pgrouting.postlbs.org/ticket/133
>
> BR,
>
> Pedro Doria Meunier
> GSM: +351961720188
> Skype: pdoriam
>
> On Thursday 11 December 2008 10:17:24 am Düster Horst wrote:
>   
>> 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
>>     
>
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   




More information about the postgis-users mailing list