[postgis-users] PgRouting schema qualified tables etc.

Pedro Doria Meunier pdoria at netmadeira.com
Thu Dec 11 02:33:27 PST 2008


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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081211/e869642a/attachment.pgp>


More information about the postgis-users mailing list