El 29/06/12 11:56, Sarah Hoffmann escribió: > This was meant to go to the list... > > ----- Forwarded message from Sarah Hoffmann <[email protected]> ----- > > Hi Adrian, > > On Fri, Jun 29, 2012 at 11:22:12AM +0200, Adrian Chapela wrote: >> I am folling instructions of: >> http://wiki.openstreetmap.org/wiki/Nominatim/Installation >> >> At step ./utils/setup.php (importing database) the import never ends because >> it is sending the next error: >> index_placex: UPDATE failed: ERROR: upper bound of FOR loop cannot be null >> CONTEXT: PL/pgSQL function "get_osm_rel_members" line 6 at FOR with integer >> loop variable >> PL/pgSQL function "placex_update" line 312 at FOR over SELECT rows >> >> The problem is when setup.php execute the next: >> nominatim -i -d nominatim -t 3 -R 4 >> >> I am using osm2pgsql 0.80 and osmosis 0.40.1 > Your osm2pgsql is most likely too old. As I can see (after done a new git clone) the osm2pgsql is the same version that I have used to import yesterday, 0.80. Now I have compiled again with 64 bits activated. > Try out the very latest version > of Nominatim from git. It comes bundled with the correct version of > osm2pgsql. Please note that the compilation instructions have changed > slightly. The wiki site has been updated. Yesterday at 19:14!! This can not be true! And maybe this change og functions.sql resolve my problems.
diff --git a/sql/functions.sql b/sql/functions.sql index 554ddf3..20e97c1 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1739,7 +1739,7 @@ DECLARE b BOOLEAN; classtable TEXT; BEGIN - RAISE WARNING 'placex_delete % %',OLD.osm_type,OLD.osm_id; + -- RAISE WARNING 'placex_delete % %',OLD.osm_type,OLD.osm_id; update placex set linked_place_id = null where linked_place_id = OLD.place_id; --DEBUG: RAISE WARNING 'placex_delete:01 % %',OLD.osm_type,OLD.osm_id; Regards! > > Sarah > > > _______________________________________________ > Geocoding mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/geocoding > _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
