| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Marcio Caetano <lima_caetano(at)yahoo(dot)com(dot)br> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Multicolumn Indexing using R-Tree |
| Date: | 2004-02-03 19:18:47 |
| Message-ID: | 401FF417.1060703@sigaev.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)sigaev(dot)ru
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolai Tufar | 2004-02-03 19:31:14 | Turkish Locale in Identifiers (contd.) |
| Previous Message | Paul Ramsey | 2004-02-03 19:13:39 | Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4] |