Ok, it's this:<div><br><div><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;"><div># SELECT assign_vertex_id('office',0.0001,'geom','id');</div><div><br></div><div>NOTICE: CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id"</div><div>CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)"</div><div>PL/pgSQL function "assign_vertex_id" line 14 at EXECUTE statement</div><div>ERROR: query string argument of EXECUTE is null</div><div>CONTEXT: PL/pgSQL function "assign_vertex_id" line 35 at EXECUTE statement</div><div><br></div><div><br></div><div>----office is a table (id int4,name varchar(20),geom geometry)----</div><div><br></div><div>thanks for the answer!</div></span></font></div><div><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></div><div><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></div><div><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></div><div><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;"><br>
----Messaggio originale----</span></font><br><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;">
Da: daniel@georepublic.de</span></font><br><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;">
Data: 3-feb-2011 10.37 AM</span></font><br><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;">
A: "pgRouting users mailing list"<pgrouting-users@lists.osgeo.org></span></font><br><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;">
Ogg: Re: [pgrouting-users] assign_vertex_id trouble</span></font><br>
<br><font face="tahoma, arial, helvetica, sans-serif"><span style="font-size: 12px;">
Can you post your query?</span></font><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 12px; "><br></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 12px; ">Daniel</div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 12px; "><br><br><div class="gmail_quote">2011/2/3 Andrea Mazzeschi <span dir="ltr"><<a href="mailto:zeusxxl@virgilio.it">zeusxxl@virgilio.it</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div style="word-wrap:break-word">Hi I'm andrea. I'm new in pgrouting, postgis and similar. I was following this useful guide <a href="http://goo.gl/FuIiF" target="_blank">http://goo.gl/FuIiF</a> to create a network topology. However when I try to execute the command<div>
<span style="font-family:Verdana, Arial, 'Bitstream Vera Sans', Helvetica, sans-serif;font-size:13px"><pre style="background-color:rgb(247, 247, 247);border-top-width:1px;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-top-style:solid;border-right-style:solid;border-bottom-style:solid;border-left-style:solid;border-top-color:rgb(215, 215, 215);border-right-color:rgb(215, 215, 215);border-bottom-color:rgb(215, 215, 215);border-left-color:rgb(215, 215, 215);margin-top:1em;margin-right:1.75em;margin-bottom:1em;margin-left:1.75em;padding-top:0.25em;padding-right:0.25em;padding-bottom:0.25em;padding-left:0.25em;overflow-x:auto;overflow-y:auto">
assign_vertex_id('<table>', float tolerance, '<geometry column', '<gid>')</pre></span><div><div>to my table, I have this response:</div></div><div><br></div><div><div><b>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>"</b></div>
<div><b>CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)"</b></div><div><b>PL/pgSQL function "assign_vertex_id" line 14 at EXECUTE statement</b></div><div><b>ERROR: query string argument of EXECUTE is null</b></div>
<div><b>CONTEXT: PL/pgSQL function "assign_vertex_id" line 35 at EXECUTE statement</b></div></div><div><b><br></b></div><div>Do anyone know what's the problem?</div><div>(sorry for my bad english)</div></div>
<div>
<span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<div><div><br>_____________________</div></div><div><br></div><div>zEuSsE</div><div>e.mail: <a href="mailto:zeusxxl@virgilio.it" target="_blank">zeusxxl@virgilio.it</a></div><div><br></div></div></span><br></span><br></span>
</div>
<br></div><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>
<br>
<br>
</div></div>