On Thu, Jun 05, 2014 at 01:59:41PM +0200, Alessandra Donnini wrote: > rerun of > ./utils/specialphrases.php --wiki-import > specialphrases.sql > psql -d nominatim -f specialphrases.sql > seems not work and I receive this kind of error for each table: > psql:specialphrases.sql:58387: ERROR: relation > "place_classtype_natural_islet" already exists > psql:specialphrases.sql:58388: ERROR: relation > "idx_place_classtype_natural_islet_centroid" already exists > psql:specialphrases.sql:58389: ERROR: relation > "idx_place_classtype_natural_islet_place_id" already exists > GRANT
Just doing the grant would have been sufficient in that case but it looks like this one did the right thing as well. So that part is ok. > After rerun tables place_classtype_%, search_name and placex are empty. This has nothing to do with the special phrases. It looks like your initial import still didn't work properly. You'll have to drop the DB and start from scratch. Make sure you log the output of the setup script and carefully check for errors after it is done. The final output should be about CREATE INDEX (a lot of them). Also, I recommend trying with a very small file first (e.g. the Liechtenstein excerpt). Sarah _______________________________________________ Geocoding mailing list [email protected] https://lists.openstreetmap.org/listinfo/geocoding
