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

[maruf rahman]

Hi

Thanks for the suggestions. I have executed the legacy.sql. Now I am
getting the following error.
Could anyone describe the workaround of this issue?

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:  query string argument of EXECUTE is null
CONTEXT:  PL/pgSQL function "assign_vertex_id" line 36 at EXECUTE statement
pgrouting-workshop=#

Thanks
Maruf


On Wed, Mar 13, 2013 at 2:28 AM, Stephen V. Mather <
svm at clevelandmetroparks.com> wrote:

> 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
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20130319/f4323d00/attachment.html>