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 statement
ERROR: query string argument of EXECUTE is null
CONTEXT: 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@georepublic.de
Data: 3-feb-2011 10.37 AM
A: "pgRouting users mailing list"pgrouting-users@lists.osgeo.org
Ogg: Re: [pgrouting-users] assign_vertex_id trouble
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 statementDo 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