[pgrouting-users] assign_vertex_id() execute error @ line 32
anton at orkney.co.jp
Mon Jul 6 05:17:56 EDT 2009
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:
> 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.
> Pgrouting-users mailing list
> Pgrouting-users at lists.postlbs.org
More information about the Pgrouting-users