[Geocoding] "type keyvalue[] does not exist" error when setup Gazetteer / Nominatim

Wolf, Gregor gregor.wolf at gmail.com
Fri Jun 4 07:56:51 BST 2010


Hello OSM-Geocoding specialists,

I'm in the process to setup Gazetteer / Nominatim on a Ubuntu karmic
Server. I've used the documentation from:
http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/gazetteer
/README.txt and after I've compiled osm2pgsql from the current SVN code I
was able to complete without to this step:

6) Add gazetteer functions to database
cat gazetteer-functions.sql | psql gazetteer
cat gazetteer-tables.sql | psql gazetteer
cat gazetteer-functions.sql | psql gazetteer

Here I get the error:

ERROR:  type keyvalue[] does not exist

when I run "cat gazetteer-functions.sql | psql gazetteer" and also this
errors when I run:

ERROR:  relation "placex" does not exist
ERROR:  relation "search_name" does not exist
ERROR:  relation "place_addressline" does not exist
ERROR:  relation "location_point" does not exist
ERROR:  relation "location_point_26" does not exist
ERROR:  relation "location_point_25" does not exist
ERROR:  relation "location_point_24" does not exist
ERROR:  relation "location_point_23" does not exist
ERROR:  relation "location_point_22" does not exist
ERROR:  relation "location_point_21" does not exist
ERROR:  relation "location_point_20" does not exist
ERROR:  relation "location_point_19" does not exist
ERROR:  relation "location_point_18" does not exist
ERROR:  relation "location_point_17" does not exist
ERROR:  relation "location_point_16" does not exist
ERROR:  relation "location_point_15" does not exist
ERROR:  relation "location_point_14" does not exist
ERROR:  relation "location_point_13" does not exist
ERROR:  relation "location_point_12" does not exist
ERROR:  relation "location_point_11" does not exist
ERROR:  relation "location_point_10" does not exist
ERROR:  relation "location_point_9" does not exist
ERROR:  relation "location_point_8" does not exist
ERROR:  relation "location_point_7" does not exist
ERROR:  relation "location_point_6" does not exist
ERROR:  relation "location_point_5" does not exist
ERROR:  relation "location_point_4" does not exist
ERROR:  relation "location_point_3" does not exist
ERROR:  relation "location_point_2" does not exist
ERROR:  relation "location_point_1" does not exist
ERROR:  relation "location_area" does not exist

"cat gazetteer-tables.sql | psql gazetteer"

Is there anyone who solved this problem?

Best regards
Gregor




More information about the Geocoding mailing list