Skip site navigation (1) Skip section navigation (2)

How to create a spatial index on point data.

From: "s anwar" <sanwar(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to create a spatial index on point data.
Date: 2007-08-16 17:48:54
Message-ID: 3e3c86f90708161048g43e7e2eeh8d053a80f431a221@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
How does once create a spatial index on point data. I did the
following and got the error given below.

create table foo(x point);
create index foo_x on foo using gist(x);
ERROR:  data type point 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.

Thanks.

Responses

pgsql-novice by date

Next:From: s anwarDate: 2007-08-16 21:13:16
Subject: Fwd: How to create a spatial index on point data.
Previous:From: Tom LaneDate: 2007-08-16 14:28:19
Subject: Re: rogue process maxing cpu and unresponsive to signals

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group