demo (#22) - Problem with online Tutorial (#142) - Message List

Problem with online Tutorial

Hi,

i tried several times to work with the online tutorial (http://pgrouting.postlbs.org/wiki/WorkshopFOSS4G2007) but i always get an error at this point: Create network topology (http://pgrouting.postlbs.org/wiki/Workshop-PrepareDikstra). I used the same data as in the tutorial.

If i use this query:

SELECT assign_vertex_id('victoria', 0.001, 'the_geom', 'gid');

I get the following error:

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 21 at execute statement

ERROR: cannot EXECUTE a null querystring SQL Status:22004 Kontext:PL/pgSQL function "assign_vertex_id" line 33 at execute statement

Thanks for help! EnochRoot?

  • Message #461

    Hi,

    Can you post here fields of your table with their types?

    • Message #462

      victoria (

      gid integer, id integer, the_geom geometry, source integer, target integer, length double precision

      ) geometry_columns (

      oid, f_table_catalog [PK] character varying(256), f_table_schema [PK] character varying(256), f_table_name [PK] character varying(256), f_geometry_column[PK] character varying(256), coord_dimension integer, srid integer, type character varying (30)

      ) spatial_ref_system (

      srid [PK] integer, auth_name character_varying(256), auth_srid integer, srtext character_varying(2048), proj4text character_varying(2048)

      ) I can send a dump of the whole table, too. Thanks for your help!

      • Message #463

        Do you have an entry for 'victoria' table in 'geometry_columns' with proper srid?

        • Message #464

          Had none...

          Now I have one (srid = 54004). Seems that I misunderstood the last point of http://pgrouting.postlbs.org/wiki/Workshop-LoadRoutingData . I thought it's optional.

          Now "SELECT assign_vertex_id('victoria', 0.001, 'the_geom', 'gid');" works without any problems. I will continue the tutorial.

          Such a stupid mistake. I really appreciate your support!!!

          • Message #465

            You are welcome!