No import any nodes where id>type integer

[denny123]

No import any nodes where id>type integer in table planet_osm_nodes.id and planet_osm_ways.nodes. After changed type INTEGER -> NUMERIC show error:

PREPARE node_changed_mark(int4) AS UPDATE planet_osm_ways SET pending = true WHERE nodes && ARRAY[$1] AND NOT pending;
failed: ERROR: operator does not exist: numeric[] && integer[]
LINE 1: ...TE planet_osm_ways SET pending = true WHERE nodes && ARRAY[$...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

[lonvia]

Did you build your osm2pgsql with 64bit id space? If you check the osm2pgsql version you should see something like this:

me@machine:~$ ./osm2pgsql/osm2pgsql
osm2pgsql SVN version 0.81.0 (64bit id space)

Recent versions of the source code will build in 64bit mode automatically, older ones still need ./configure --enable-64bit-ids.

[denny123]

opengeo@opengeo:~$ osm2pgsql
osm2pgsql SVN version 0.70.5
How configure in 64bit?

[lonvia]

This version is far too old. Check out the current source code here from github and build your own version. You can find some hints about the required dependencies in the wiki.

[denny123]

svn co http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/
cd osm2pgsql/
./autogen.sh
./configure (without --enable-64bit-ids)
make
opengeo@opengeo:~/write/osm2pgsql$ ./osm2pgsql
osm2pgsql SVN version 0.81.0 (64bit id space)
Thank you!

[lonvia]

There was a bug in the configure script. Just fixed that, --enable-64bit-ids should work now too.