[Live-demo] [OSGeo] #774: pgrouting quickstart examples do not work

[OSGeo]

#774: pgrouting quickstart examples do not work
-----------------------+----------------------------------------------------
 Reporter:  darkblueb  |       Owner:  live-demo@…              
     Type:  defect     |      Status:  new                      
 Priority:  major      |   Milestone:                           
Component:  LiveDVD    |    Keywords:  pgrouting, RC2           
-----------------------+----------------------------------------------------
 run LiveDVD RC2

 user at 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)

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/774>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.