Home > mailing lists

create gist index - Mailing list pgsql-general

From	Jose Manuel Sanchez
Subject	create gist index
Date	April 29, 2003 06:51:26
Msg-id	005501c30e24$6ade7040$2000a8c0@mayik Whole thread Raw
List	pgsql-general

Tree view

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:

From: g.hintermayer@inode.at (Gerhard Hintermayer)
Date: 29 April 2003, 06:28:47
Subject: Backend memory leakage when inserting

From: Antti Haapala
Date: 29 April 2003, 06:53:22
Subject: Re: timestamps and dates

create gist index - Mailing list pgsql-general

Previous

Next