create gist index - Mailing list pgsql-general

From Jose Manuel Sanchez
Subject create gist index
Date
Msg-id 002601c30e55$6e14c5d0$2000a8c0@mayik
Whole thread Raw
In response to Slow Queries with OR's?  ("Mad Hatter" <mad_hatter_@hotmail.com>)
List 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.


pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Re: Importing from Access 2000?
Next
From: Oliver Elphick
Date:
Subject: Re: Importing from Access 2000?