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

[Anton Patrushev]

Hi Vladislav,

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

Anton.

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
>