[OSM-dev] nominatim / windows

[Sarah Hoffmann]

Hi,

On Mon, Jan 20, 2014 at 09:02:23PM +0100, Dominik Perpeet wrote:
> Some may remember me from previous messages (a long time ago) about
> osm2pgsql on Windows. I've gone a step further this time and compiled
> nominatim as well and ran it all using a modified wamp.
> 
> Things seem to work on the surface, but for some reason nominatim isn't
> really generating any data. I've used pretty much the latest version
> available of osm2pgsql and nominatim.
> 
> Any hints or thoughts?
> 
> I have uploaded more extensive logs to http://customdebug.com/osm/nominatim/
> (database messages, general messages and table lenghts [row counts])

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