[Geocoding] Problems while creating your own gazetteer server

[Ciprian Talaba]

Hi guys,

I am trying to create my own gazetteer service (using the new code from
Brian) that will be loaded with data from Romania only (at least for now)
and I am seeing some errors while following the steps in the README file:

1. when I first try to execute commands from gazetteer-functions.sql I get
something like:

$ cat gazetteer-functions.sql | psql gazetteer
....
ERROR:  type wordscore[] does not exist
...
CREATE FUNCTION
ERROR:  type "place_boundingbox" does not exist
ERROR:  type "place_boundingbox" does not exist
ERROR:  type "place_boundingbox" does not exist
CONTEXT:  compile of PL/pgSQL function "update_place" near line 2
CREATE FUNCTION
...
which I believe is expected at some point because the next command will
create the place_boundingbox table.

2. When trying to execute gazetteer-tables.sql I get some errors also, but
the one that I don't understand is:
...
CREATE INDEX
CREATE INDEX
ERROR:  operator class "gin_trgm_ops" does not exist for access method "gin"
GRANT
...
Is this a show stopper?

3. When I execute gazetteer-functions.sql the second time I only get one
error:
...
CREATE FUNCTION
ERROR:  type wordscore[] does not exist
CREATE FUNCTION
...
I am missing something here, is this type defined anywhere else?

With all these error I am able to connect to the web interface (installed
locally of course), but I don't see any result, no matter what search terms
I try. Is there a way to get into a 'debug' mode, to see exactly what is
wrong?

Thanks,
Ciprian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20091127/8ce32544/attachment.html>