[pgrouting-users] assign_vertex_id() execute error @ line 32
Vladislav Shikhov
vladshikhov at gmail.com
Mon Jul 6 05:36:09 EDT 2009
Hello,
It was ok with ways & geometry_columns, the problem disappear after
I've rebuild pgroute from trunk.
Thanx.
On Mon, Jul 6, 2009 at 1:17 PM, Anton Patrushev<anton at orkney.co.jp> wrote:
> 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
>>
>
> _______________________________________________
> 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