| From: | Paul Ramsey <pramsey(at)refractions(dot)net> |
|---|---|
| To: | lima_caetano(at)yahoo(dot)com(dot)br (Marcio Caetano) |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Multicolumn Indexing using R-Tree |
| Date: | 2004-02-03 19:52:05 |
| Message-ID: | 71121FA0-5682-11D8-B42D-000393D33C2E@refractions.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-03 20:06:10 | Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4] "permissions problem" with pl/pgsql function ) |
| Previous Message | Nicolai Tufar | 2004-02-03 19:31:14 | Turkish Locale in Identifiers (contd.) |