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

pgRouting pgrouting-users
1

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

2

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

3

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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

4

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 ™.

best regards Gunnar

2012/10/2 Daniel Kastl <daniel@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@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