Hello !

I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that
uses more than one column in a table.

When I run the instruction it appears this message bellow:

DefineIndex: access method "rtree" does not support multi-column
indexes


How can I solve this problem ? 
Is it a limitation of PostgreSQL or the R-Tree concept  ?

Thank you in advance.

Mï¿½rcio Caetano.

3 Feb 2004 06:56:11 -0800
lima_caetano@yahoo.com.br (Marcio Caetano)
Multicolumn Indexing using R-Tree
Try contrib/rtree_gist

Marcio Caetano wrote:
> Hello !
> 
> I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that
> uses more than one column in a table.
> 
> When I run the instruction it appears this message bellow:
> 
> DefineIndex: access method "rtree" does not support multi-column
> indexes
> 
> 
> How can I solve this problem ? 
> Is it a limitation of PostgreSQL or the R-Tree concept  ?
> 
> Thank you in advance.
> 
> Mï¿½rcio Caetano.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

-- 
Teodor Sigaev                                  E-mail: teodor@sigaev.ru

Tue, 03 Feb 2004 22:18:47 +0300
Teodor Sigaev <teodor@sigaev.ru>
Re: Multicolumn Indexing using R-Tree

Try using GiST rtree (examples in contrib), GiST supports multi-key 
indexes.

On Tuesday, February 3, 2004, at 06:56 AM, Marcio Caetano wrote:

> I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that
> uses more than one column in a table.
>
> When I run the instruction it appears this message bellow:
>
> DefineIndex: access method "rtree" does not support multi-column
> indexes
>
> How can I solve this problem ?
> Is it a limitation of PostgreSQL or the R-Tree concept  ?
>
> Thank you in advance.
>
> Márcio Caetano

Tue, 03 Feb 2004 11:52:05 -0800
Paul Ramsey <pramsey@refractions.net>
Re: Multicolumn Indexing using R-Tree