[pgrouting-users] Functions without "ST_" prefix (into .sql)

[Gunnar Rangøy]

Hi Eduardo,

I guess this is a problem due to that these functions where removed with
the 2.x release of postgis.

I used the quick-fix - ie loading compatibility wrappers for these
deprecated functions.

There are two scripts which you can load, which I found in my installation
here;

/usr/share/postgresql/9.1/contrib/postgis-2.0/legacy.sql
/usr/share/postgresql/9.1/contrib/postgis-2.0/legacy_minimal.sql

There are two more which you might find relevant;
/usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis_legacy.sql
/usr/share/postgresql/9.1/contrib/postgis-2.0/uninstall_legacy.sql


I think it was enough to load the minimal set.


It might not be wise to encourage use of these because it might postpone
the real solution, but for us in a hurry - it might be the right way (tm).


best regards Gunnar


2012/10/2 Daniel Kastl <daniel at georepublic.de>

> Hi Eduardo,
>
> You're right. There are several places where the ST_ prefix is missing.
> Mario has started some time ago to cleanup the wrapper functions, adding
> the prefix where it was missing but also getting rid of unused code and
> renaming and cleaning up the functions:
> https://github.com/mbasa/pgrouting/commits/master
>
> This just affects the wrappers as far as I know, so maybe you want to take
> a look and try it out.
>
> Daniel
>
>
> On Tue, Oct 2, 2012 at 2:47 AM, Eduardo Kanegae <eduardo.kanegae at gmail.com
> > wrote:
>
>> hi,
>>
>> I'm building pgRouting 1.05 in a CentOS 6.3 box, but I'm noting that
>> in some .sql files (eg. routing_core_wrappers.sql) is missing 'ST_'
>> prefix in functions such as:
>> *length
>> *srid
>> *x
>> *y
>>
>> Should I fix these manually or download its current source?
>>
>> thanks in advance
>>
>> Eduardo Patto Kanegae
>> http://www.webmapit.com | @webmapit
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>


-- 
 Gunnar Rangøy  System developer  Trådløse Trondheim / Wireless Trondheim
tradlosetrondheim.no  +47 99 36 06 99
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20121002/c11102dd/attachment.html>