R: Re: [pgrouting-users] assign_vertex_id trouble

[zeusxxl at virgilio.it]

Ok, it's this:
# SELECT assign_vertex_id('office',0.0001,'geom','id');
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 statementERROR:  query string argument of EXECUTE is nullCONTEXT:  PL/pgSQL function "assign_vertex_id" line 35 at EXECUTE statement

----office is a table (id int4,name varchar(20),geom geometry)----
thanks for the answer!




----Messaggio originale----

Da: daniel at georepublic.de

Data: 3-feb-2011 10.37 AM

A: "pgRouting users mailing list"<pgrouting-users at lists.osgeo.org>

Ogg: Re: [pgrouting-users] assign_vertex_id trouble



Can you post your query?
Daniel

2011/2/3 Andrea Mazzeschi <zeusxxl at virgilio.it>


Hi I'm andrea. I'm new in pgrouting, postgis and similar. I was following this useful guide http://goo.gl/FuIiF to create a network topology. However when I try to execute the command


assign_vertex_id('<table>', float tolerance, '<geometry column', '<gid>')to my table, I have this response:
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 statementERROR:  query string argument of EXECUTE is null

CONTEXT:  PL/pgSQL function "assign_vertex_id" line 35 at EXECUTE statement
Do anyone know what's the problem?(sorry for my bad english)





_____________________
zEuSsEe.mail: zeusxxl at virgilio.it






_______________________________________________

Pgrouting-users mailing list

Pgrouting-users at lists.osgeo.org

http://lists.osgeo.org/mailman/listinfo/pgrouting-users




-- 
Georepublic UG &amp; 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/20110203/4f0ac919/attachment-0001.html