create gist index

From: Jose Manuel Sanchez <jose(dot)sanchez(at)batmap(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: create gist index
Date: 2003-04-29 07:53:26
Message-ID: 005501c30e24$6ade7040$2000a8c0@mayik
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have installed a Postgresql 7.32 and a Postgis 0.7.3 on a Suse 8.0 and I have a problem when I try to create a GIST index

CREATE INDEX indx_cname
ON roads_geom
USING GIST ( geom_colum GIST_GEOMETRY_OPS );

I got the following error:

ERROR: DefineIndex: operator class "gist_geometry_ops" not supported by access method "gist"

Do you have any idea??? I musy update the PostgreSQL with any patch?¿?¿?


Thank a lot.

Best Regards.

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-04-29 08:35:36 Re: Estimating space required for indexes
Previous Message Antti Haapala 2003-04-29 07:52:41 Re: timestamps and dates