Re: [GENERAL] MaxIndexAttributeNumber limit - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] MaxIndexAttributeNumber limit
Date
Msg-id 199808280416.AAA08776@candle.pha.pa.us
Whole thread Raw
In response to MaxIndexAttributeNumber limit  (Anthony Symons <symons@citr.com.au>)
List 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 by date:

Previous
From: Anthony Symons
Date:
Subject: MaxIndexAttributeNumber limit
Next
From: aaa1services@mailexcite.com
Date:
Subject: Do it Yourself or We can do it For You