Обсуждение: MaxIndexAttributeNumber limit

Поиск
Список
Период
Сортировка

MaxIndexAttributeNumber limit

От
Anthony Symons
Дата:
Hi all,
I see that MaxIndexAttributeNumber is set to 7 in itup.h and
memutils.h.

However, I would like to use a unique index with 8 fields.
Can I just change these defines and recompile, or is there
a reason for this limit on index tuple index attributes?

Cheers
Anthony
--
--------------------------------------------------------
Dr Anthony Symons       | Phone: +61-73-259-2365
CiTR Pty Ltd            | Fax:   +61-73-259-2259
John Oxley Centre       |
339 Coronation Drive    | Email: a.symons@citr.com.au
MILTON                  |
QLD 4064 AUSTRALIA      | Postal: PO Box 1643
--------------------------------------------------------


Re: [GENERAL] MaxIndexAttributeNumber limit

От
Bruce Momjian
Дата:
> Hi all,
> I see that MaxIndexAttributeNumber is set to 7 in itup.h and
> memutils.h.
>
> However, I would like to use a unique index with 8 fields.
> Can I just change these defines and recompile, or is there
> a reason for this limit on index tuple index attributes?

Indexed fields are stored in an int28 column, which holds eight int2
values which are the attribute numbers.  Changing that is more work,
because you have to change all their support functions.



--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)