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

[Stephen V. Mather]

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