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

[maruf rahman]

Hi
I am in section 5.2 of this tutorial
<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"

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20130312/bab32a29/attachment.html>