[Geocoding] Gazetteer instalation

[Michal Palenik]

hello, i have problems installing/configuring Gazetteer on debian
testing.

i have osm2pgsql binary from packages, Gazetteer from todays svn
database creation is ok, osm2pgsql is also ok (after correcting
duplicate nodes)

i have problems with step:
cat gazetteer-functions.sql | psql -q gazetteer

ERROR:  typy keyvalue[] does not exist

should it be created by ?

 CREATE TYPE keyvalue AS (
  key TEXT,
    value TEXT
      );


(i could not find it anywhere, neither in
contrib nor in gazetteer)


other missing types are:
wordscore
place_boundingbox

also in gazetteer-index.sql
place and placex have different structure, which causes
insert into placex select * from place where osm_type = 'N';
to fail


michal

ps:
postgresql-contrib-8.3 needs to be installed

pg_config is sometimes faulty, so i had to change the makefile to
PGXS := $(shell /usr/lib/postgresql/8.3/bin/pg_config --pgxs)

notes on role 'twain' are in some sql scripts



-- 
michal palenik
www.freemap.sk
http://wiki.freemap.sk