Re: Cannot use more than 16 attributes in an index

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.