On Tue, 6 Aug 2002, Thomas Bolden wrote:
> I have a table with 17 attributes in the primary key. When I try to create the table I get the message
> "ERROR: Cannot use more than 16 attributes in an index".
> The table description are set by a multi-state consortium. This is a make or break for Postgresql. Is there a way
toincrease this limit.
> I have installed Ver 7.2.1 Postgresql on FreeBSD 4.6.
Thank god for having the source eh?
Just edit this file:
/path/to/src/postgresql-7.2.1/src/include/pg_config.h.in
and on about line 167 you'll find a couple of lines like this:
#define INDEX_MAX_KEYS 16
#define FUNC_MAX_ARGS INDEX_MAX_KEYS
Just change that 16 to 32 or something like it, go the the
/path/to/src/postgresql-7.2.1 directory and do
./configure (your --configuration-switches go here...)
make
make install
and you're set.