From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | symons(at)citr(dot)com(dot)au (Anthony Symons) |
Cc: | pgsql-general(at)postgreSQL(dot)org, symons(at)citr(dot)com(dot)au |
Subject: | Re: [GENERAL] MaxIndexAttributeNumber limit |
Date: | 1998-08-28 04:16:38 |
Message-ID: | 199808280416.AAA08776@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Marsden | 1998-08-28 13:47:06 | Deadlocking: "xid loop detected" |
Previous Message | Anthony Symons | 1998-08-28 03:20:33 | MaxIndexAttributeNumber limit |