[pgrouting-users] assign_vertex_id() execute error @ line 32

Vladislav Shikhov vladshikhov at gmail.com
Sun Jul 5 09:10:42 EDT 2009


Hello,

i've created postgres db and load data there with osm2pgrouting, but i
have a problem with executing assign_vertex_id('ways', 0.00001,
'the_geom', 'gid'). Can anybody here help me?

The postgres output is:
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:  cannot EXECUTE a null querystring
CONTEXT:  PL/pgSQL function "assign_vertex_id" line 32 at EXECUTE statement

i've tried a patch from
http://pgrouting.postlbs.org/discussion/16/184, but get no result.
Thanx.



More information about the Pgrouting-users mailing list