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

Anton Patrushev anton at orkney.co.jp
Mon Jul 6 05:17:56 EDT 2009

Hi Vladislav,

Please make sure that you have an entry for your 'ways' table in
'geometry_columns' table and it has proper SRID value.


On Sun, Jul 5, 2009 at 10:10 PM, Vladislav Shikhov<vladshikhov at gmail.com> wrote:
> 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.
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.postlbs.org
> http://lists.postlbs.org/mailman/listinfo/pgrouting-users

More information about the Pgrouting-users mailing list