demo (#22) - Problem with online Tutorial (#142) - Message List
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?
anton05/08/08 11:22:29 (3 years ago)-
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!
EnochRoot05/08/08 16:28:32 (3 years ago)-
Message #463
Do you have an entry for 'victoria' table in 'geometry_columns' with proper srid?
anton05/08/08 16:43:53 (3 years ago)-
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!!!
EnochRoot05/08/08 16:56:14 (3 years ago)
-
-
-