NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hello, I am getting this errors bellow when I run ./setup --index, or ./setup --all --osm-file ./panet.osm What is causing the problem? I have postgresql 9.1 and postgis 1.5.4 installed. Thank You

index_placex: UPDATE failed: ERROR:  operator does not exist: bigint[] @> integer[]
LINE 1: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_i...
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
QUERY:  select * from planet_osm_rels where parts @> ARRAY[NEW.osm_id::integer] and members @> ARRAY['n'||NEW.osm_id]
CONTEXT:  PL/pgSQL function "placex_update" line 133 at FOR over SELECT rows
index_placex: UPDATE failed: ERROR:  operator does not exist: bigint[] @> integer[]
LINE 1: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_i...
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
QUERY:  select * from planet_osm_rels where parts @> ARRAY[NEW.osm_id::integer] and members @> ARRAY['n'||NEW.osm_id]
CONTEXT:  PL/pgSQL function "placex_update" line 133 at FOR over SELECT rows
index_placex: UPDATE failed: ERROR:  operator does not exist: bigint[] @> integer[]
LINE 1: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_i...

asked 18 Apr '12, 17:45

skypik's gravatar image

skypik
1111
accept rate: 0%


What is meant here is 64-bit id space which is currently not supported with Nominatim. Make sure that in osm2pgsql #define OSMID64 is commented out in osmtypes.h.

permanent link

answered 23 Apr '12, 19:51

lonvia's gravatar image

lonvia
6.2k25789
accept rate: 40%

Did you compile osm2pgsql with 64bit support? I had the same error and switched to 32bit

permanent link

answered 19 Apr '12, 01:00

Norm1's gravatar image

Norm1
126458
accept rate: 0%

Yes, I did

file /usr/local/bin/osm2pgsql /usr/local/bin/osm2pgsql: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, not stripped

(19 Apr '12, 08:09) skypik

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×293
×17
×15
×3

question asked: 18 Apr '12, 17:45

question was seen: 5,002 times

last updated: 23 Apr '12, 20:16

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum