[Geocoding] empty search_name tables

[Sarah Hoffmann]

On Tue, Mar 17, 2015 at 11:48:58AM +0100, Carlos Alberto Castaño Moraga wrote:
> Hi Sarah,
> 
> Thank you very much for your answer. Here is the output of the things I had
> to check:
> 
> A) run ./utils/setup.php --create-functions
> 
> I think there is no error. Here you can find the output.
> 
> B)  Triggers installed (psql nominatim and the '\d placex')
> 
> Triggers:
>     placex_before_delete AFTER DELETE ON placex FOR EACH ROW EXECUTE
> PROCEDURE placex_delete()
>     placex_before_insert BEFORE INSERT ON placex FOR EACH ROW EXECUTE
> PROCEDURE placex_insert()
>     placex_before_update BEFORE UPDATE ON placex FOR EACH ROW EXECUTE
> PROCEDURE placex_update()
> 
> C) check the number of items to be indexed:
>   SELECT count(*) FROM placex WHERE indexed_status > 0;
> 
>  count
> --------
>  111900
> (1 row)
> 
> I think everything is OK. What would be the next step??

This looks all perfectly ok. I don't see why it shouldn't work.
Just run the following again:

./utils/setup.php --index

Afterwards the number of items to be indexed should be 0. If
that works, also check if there is an index idx_placex_rank_search on
placex.

Sarah