Fwd: 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: Fwd: How to create a spatial index on point data.
Date: 2007-08-16 21:13:16
Message-ID: 3e3c86f90708161413y183a0d3aie41894a48638d8d1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Never mind. I found an earlier posting by Tom Lane related to this issue.

---------- Forwarded message ----------
From: s anwar <sanwar(at)gmail(dot)com>
Date: Aug 16, 2007 10:48 AM
Subject: How to create a spatial index on point data.
To: pgsql-novice(at)postgresql(dot)org

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jon Jensen 2007-08-16 21:27:38 Re: rogue process maxing cpu and unresponsive to signals
Previous Message s anwar 2007-08-16 17:48:54 How to create a spatial index on point data.