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

[Jelmer Baas]

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