How does your network table look like?<div>Did you make sure that column names match and also the data types?</div><div><br></div><div>Daniel</div><div><br></div><div><br><br><div class="gmail_quote">2011/2/15 Piyush Shah <span dir="ltr"><<a href="mailto:piyush_shah@ymail.com">piyush_shah@ymail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font:inherit">I am new to pgroutine so ineed some help <br>
<br>i am using PostgreSql 8.4 , Postgis 1.5.1, pgRouting-1.03_pg-8.4.2<br><br>But when i trying to create network node through assign_vertex_id<br><br>"SELECT assign_vertex_id ('India_highway', 0.00001, 'the_geom', 'gid');"<br>
<br>it gives following ERROR<br><br><span style="color:rgb(255, 0, 0)">[WARNING ] SELECT assign_vertex_id ('India_highway', 0.00001, 'the_geom', 'gid')</span><br style="color:rgb(255, 0, 0)"><span style="color:rgb(255, 0, 0)"> NOTICE: CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "<a href="http://vertices_tmp.id" target="_blank">vertices_tmp.id</a>"</span><br style="color:rgb(255, 0, 0)">
<span style="color:rgb(255, 0, 0)"> CONTEXT: SQL
statement "CREATE TABLE vertices_tmp (id serial)"</span><br style="color:rgb(255, 0, 0)"><span style="color:rgb(255, 0, 0)"> PL/pgSQL function "assign_vertex_id" line 14 at EXECUTE statement</span><br style="color:rgb(255, 0, 0)">
<span style="color:rgb(255, 0, 0)"> ERROR: query string argument of EXECUTE is null</span><br style="color:rgb(255, 0, 0)"><span style="color:rgb(255, 0, 0)"> CONTEXT: PL/pgSQL function "assign_vertex_id" line 20 at EXECUTE statement</span><br>
<br><br>so please help me what is the problem<br><br><div><font face="comic sans ms" color="#7f3f00"><strong><em><u>PIYUSH M SHAH<img></u></em></strong></font></div></td></tr></tbody></table><br><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>
</div>