[Cartoweb-dev] Problem with demoRouting Extension

Radhika radhikadubey at infobase.in
Tue Apr 3 06:40:24 EDT 2007

Hi all ,
              when I am trying to do   SELECT assign_vertex_id('road', 0.1);

     I am getting following errors,
     -- While Executing query First time
SELECT assign_vertex_id('road', 1);

ERROR:  new row for relation "vertices_tmp" violates check constraint "enforce_srid_the_geom"
CONTEXT:  SQL statement "INSERT INTO vertices_tmp (the_geom) VALUES ( $1 )"
PL/pgSQL function "point_to_id" line 11 at SQL statement
PL/pgSQL function "assign_vertex_id" line 22 at assignment

-- While Executing the same query Second time:
SELECT assign_vertex_id('road', 1);

ERROR:  relation with OID 18309 does not exist
CONTEXT:  SQL statement "SELECT  id, the_geom FROM vertices_tmp WHERE distance(the_geom,  $1 ) <  $2 "
PL/pgSQL function "point_to_id" line 7 at select into variables
PL/pgSQL function "assign_vertex_id" line 22 at assignment .

Can any one suggest me why these errors are occurring and how can I rectify them?

Thanks & Regards,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-dev/attachments/20070403/34879845/attachment.html

More information about the Cartoweb-dev mailing list