[OSM-dev] nominatim / windows

[Dominik Perpeet]

Thanks for the pointers to the relevant code sections. I don't think the
error is there, though:

- The script doesn't seem to abort, since in the code pretty much the
last action is to create the table wikipedia_redirect, which was indeed
created in my setup.
- placex and place have their triggers and are not empty

Some other step seems to fail silently, any ideas?

Thanks,
-Dominik
> Looking at the table sizes, it looks like loading the data[1] does not work
> properly. There should be some INSERT triggers on placex which seem to be
> missing. They should be set from an SQL script around here[2].
>
> My guess would be that your version of psql immediately stops the scripts
> when it encounters an error while the unix version just skips over them.
> There are some expected fails which you can also see in your logs:
>
> <snip>
> FEHLER:  Typ A»place_boundingboxA« existiert nicht
> FEHLER:  Typ A»place_boundingboxA« existiert nicht
> FEHLER:  Typ A»place_boundingboxA« existiert nicht
> LINE 4:   result place_boundingbox;
> <snap>
>
> It should really just ignore them and continue.
>
> Sarah
>
>
> [1] https://github.com/twain47/Nominatim/blob/master/utils/setup.php#L377
> [2] https://github.com/twain47/Nominatim/blob/master/sql/tables.sql#L224