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

[Daniel Kastl]

How does your network table look like?
Did you make sure that column names match and also the data types?

Daniel



2011/2/15 Piyush Shah <piyush_shah at ymail.com>

> 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*
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110216/463136a9/attachment.html