[pgrouting-users] ERROR: function startpoint(geometry) does not exist

[Stephen V. Mather]

Yes, the nice work that GreenInfo did for us with pgRouting notes the following:

-- Install PostGIS and PgRouting
-- For the most part PgRouting works fine with PostGIS 2.0 but I did need to fix some function names as noted below.
--
-- Changes to routing_core_wrappers.sql
-- * replace "length::double precision as cost" with "cost"; the cost field is now required but we can weight routes by something other than length
-- * fixed numerous references to X() and Y() and SRID() and SETSRID() and STARTPOINT() and ENDPOINT() to use the ST_* versions
-- Changes to routing_topology.sql
-- * assign_vertex_id() call to addGeometryColumn() now uses 3 dimensions instead of 2

The last of these is because we are using 3D shapes to get terrain profiles for our trails... .

Best,
Steve

  Stephen V. Mather
GIS Manager
(216) 635-3243 (Work)
clevelandmetroparks.com


________________________________________
From: pgrouting-users-bounces at lists.osgeo.org [pgrouting-users-bounces at lists.osgeo.org] on behalf of Jelmer Baas [baas at speerit.nl]
Sent: Tuesday, March 12, 2013 3:20 PM
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] ERROR: function startpoint(geometry) does not exist

I tried this a while back, and found that it's not all that much work to re-write the functions to support Postgis 2.0: the only requirement was adding 'ST_' to all most calls.

Regards,
Jelmer


-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Stephen V. Mather
Sent: Tuesday, March 12, 2013 19:32
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] ERROR: function startpoint(geometry) does not exist

To echo Stephen, in my experience, running the legacy.sql file against your database eliminates all the compatibility issues.

Best,
Steve

  Stephen V. Mather
GIS Manager
(216) 635-3243 (Work)
clevelandmetroparks.com


________________________________________
From: pgrouting-users-bounces at lists.osgeo.org [pgrouting-users-bounces at lists.osgeo.org] on behalf of Stephen Woodbridge [woodbri at swoodbridge.com]
Sent: Tuesday, March 12, 2013 2:13 PM
To: pgrouting-users at lists.osgeo.org
Subject: Re: [pgrouting-users] ERROR: function startpoint(geometry) does not exist

Right you are using postgis 2.0 and the tutorial was written for postgis
1.5.x

You might solve some of these problems but installing legacy.sql.
google: postgis 2.0 legacy.sql

-steve

On 3/12/2013 1:56 PM, maruf rahman wrote:
> Hi
> I am in section 5.2 of thistutorial  <http://workshop.pgrouting.org/chapters/topology.html>.
>
> When i run this command
>
>
> /*
> SELECT*//*  assign_vertex_id('ways',  0.00001,  'the_geom',  'gid'*//*);*/
>
>
>
> i get the following error/*
>
> pgrouting-workshop=# SELECT assign_vertex_id('ways', 0.00001, 'the_geom', 'gid');
> NOTICE:  CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id  <http://vertices_tmp.id>"
>
>
> CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id serial)"
> PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement
> ERROR:  function startpoint(geometry) does not exist
> LINE 1: SELECT gid AS id, StartPoint(the_geom) AS source, EndPoint(t...
>
>
>                            ^
> HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
> QUERY:  SELECT gid AS id, StartPoint(the_geom) AS source, EndPoint(the_geom) as target FROM ways
>
>
> CONTEXT:  PL/pgSQL function "assign_vertex_id" line 27 at FOR over EXECUTE statement
> pgrouting-workshop=#
>
> */
>
> Seems like I am missing the startpoint(geometry) function.
>
>
> How can I fix this?
>
> Thanks
>
> Maruf
>
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users