[OSM-dev] db:migrate

[Tom Hughes]

On 15/03/10 07:46, Kirill Bestoujev wrote:

> PGError: ERROR:  data type integer has no default operator class for
> access method "gist"
> HINT:  You must specify an operator class for the index or define a
> default operator class for the data type.
> : CREATE  INDEX "changesets_bbox_idx" ON "changesets" USING GIST
> ("min_lat", "max_lat", "min_lon", "max_lon")

You need to add btree_gist.sql from the postgres contrib package to the 
database.

> As far as I see the migration contains an error - min_lat, min_lonm
> max_lat, max_lon are integer, not geometry, so it is impossible to build
> a gist index on them...

It's perfectly possible - a point geometry is just two integers after 
all. You just need that contrib package.

> Looks like it should be changed from gist to btree.

That would defeat the object, which is to allow efficient 
multidimensional lookups.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://compton.nu/