Re: [GENERAL] MaxIndexAttributeNumber limit

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] MaxIndexAttributeNumber limit
Дата
Msg-id 199808280416.AAA08776@candle.pha.pa.us
обсуждение исходный текст
Ответ на MaxIndexAttributeNumber limit  (Anthony Symons <symons@citr.com.au>)
Список pgsql-general
> 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)

В списке pgsql-general по дате отправления:

Предыдущее
От: Anthony Symons
Дата:
Сообщение: MaxIndexAttributeNumber limit
Следующее
От: aaa1services@mailexcite.com
Дата:
Сообщение: Do it Yourself or We can do it For You