id,summary,reporter,owner,description,type,status,priority,milestone,component,resolution,keywords,cc 774,pgrouting quickstart examples do not work,darkblueb,live-demo@…,"run LiveDVD RC2 user@osgeo-live:/home/shared$ psql pgrouting psql (8.4.8) Type ""help"" for help. pgrouting=# \d List of relations Schema | Name | Type | Owner --------+---------------------+----------+------- public | classes | table | user public | geography_columns | view | user public | geometry_columns | table | user public | nodes | table | user public | spatial_ref_sys | table | user public | types | table | user public | vertices_tmp | table | user public | vertices_tmp_id_seq | sequence | user public | ways | table | user (9 rows) pgrouting=# SELECT * FROM shortest_path(' pgrouting'# SELECT gid as id, pgrouting'# source::integer, pgrouting'# target::integer, pgrouting'# length::double precision as cost pgrouting'# FROM ways', pgrouting(# 1888, 4738, false, false); vertex_id | edge_id | cost -----------+---------+------ (0 rows) pgrouting=# SELECT gid, AsText(the_geom) AS the_geom pgrouting-# FROM dijkstra_sp('ways', 1888, 4738); gid | the_geom -----+---------- (0 rows) pgrouting=# \l+ pgrouting=# \df dijkstra_sp pgrouting=# \d ways pgrouting=# select min(gid), max(gid), count(gid) from ways; min | max | count -----+-------+------- 1 | 10640 | 8486 (1 row) pgrouting=# select gid from ways where gid = 1888; gid ------ 1888 (1 row) ^ pgrouting=# select gid from ways where gid = 4738; gid ----- (0 rows) pgrouting=# select gid from ways where gid > 4700 and gid < 5000; pgrouting=# select gid from ways where gid > 4700 and gid < 5000 order by gid; pgrouting=# SELECT gid, AsText(the_geom) AS the_geom FROM dijkstra_sp('ways', 1888, 4739); gid | the_geom -----+---------- (0 rows) pgrouting=# SELECT gid, AsText(the_geom) AS the_geom FROM dijkstra_sp('ways', 1888, 4732); gid | the_geom -----+---------- (0 rows) ",defect,closed,major,,OSGeoLive,fixed,"pgrouting, RC2",