[pgrouting-users] assign_vertex_id trouble

pgRouting pgrouting-users
1

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 statement
ERROR: 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)

zEuSsE
e.mail: zeusxxl@virgilio.it

2

Can you post your query?

Daniel

2011/2/3 Andrea Mazzeschi <zeusxxl@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 statement
ERROR: 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)

zEuSsE
e.mail: zeusxxl@virgilio.it

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de