Multicolumn Indexing using R-Tree

From: lima_caetano(at)yahoo(dot)com(dot)br (Marcio Caetano)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Multicolumn Indexing using R-Tree
Date: 2004-02-03 14:56:11
Message-ID: 6e15fe24.0402030656.7a3bc91b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-02-03 15:05:34 Re: [pgsql-hackers-win32] Sync vs. fsync during checkpoint
Previous Message Tom Lane 2004-02-03 14:49:16 Re: [PATCHES] log session end - again