[pgrouting-users] Cannot Create a Network Nodes network nodes

Piyush Shah piyush_shah at ymail.com
Tue Feb 15 06:02:34 EST 2011


I am new to pgroutine so ineed some help 

i am using PostgreSql 8.4 , Postgis 1.5.1, pgRouting-1.03_pg-8.4.2

But when i trying to create network node through assign_vertex_id

"SELECT assign_vertex_id ('India_highway', 0.00001, 'the_geom', 'gid');"

it gives following ERROR

[WARNING  ] SELECT assign_vertex_id ('India_highway', 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 14 at EXECUTE statement
            ERROR:  query string argument of EXECUTE is null
            CONTEXT:  PL/pgSQL function "assign_vertex_id" line 20 at EXECUTE statement


so please help me what is the problem

PIYUSH M SHAH

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110215/35406535/attachment.html


More information about the Pgrouting-users mailing list