[Live-demo] [OSGeo] #1089: pgRouting needs legacy.sql

[OSGeo]

#1089: pgRouting needs legacy.sql
---------------------+------------------------------------------------------
 Reporter:  hamish   |       Owner:  live-demo@…              
     Type:  task     |      Status:  new                      
 Priority:  blocker  |   Milestone:  OSGeoLive6.5             
Component:  LiveDVD  |    Keywords:  6.5, pgrouting, postgis  
---------------------+------------------------------------------------------

Comment(by hamish):

 hopefully the upgrade to PostGIS 2.0 (+legacy.sql) is ok now thanks to
 Brian with r9819,20.

 this seems to work:

 {{{
   SELECT name FROM ways;
 }}}

 but when I run the quickstart I get this error from the Dijkstra query:
 {{{
   ERROR:  source contains a null value
 }}}

 the main /var/log/postgres log contains a number of errors which might or
 might not be relevant.

 The wrapper function from the quickstart, both with an without
 ST_AsText(), gives the same error, with this added:
 {{{
   CONTEXT: PL/pgSQL function "dijkstra_sp" line 13 at FOR over EXECUTE
 statement
 }}}


 see also #1094



 thanks,
 Hamish

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1089#comment:1>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.