MaxIndexAttributeNumber limit

Started by Anthony Symonsover 27 years ago2 messagesgeneral
Jump to latest
#1Anthony Symons
symons@citr.com.au

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
--------------------------------------------------------

#2Bruce Momjian
bruce@momjian.us
In reply to: Anthony Symons (#1)
Re: [GENERAL] MaxIndexAttributeNumber limit

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)