Re: Cannot use more than 16 attributes in an index - Mailing list pgsql-general

From Ralph Graulich
Subject Re: Cannot use more than 16 attributes in an index
Date
Msg-id Pine.LNX.4.21.0208062106200.25616-100000@shauny.shauny.de
Whole thread Raw
In response to Cannot use more than 16 attributes in an index  ("Thomas Bolden" <tbolden@mail.state.mo.us>)
List pgsql-general
> 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".

After configuring your source, you should edit src/include/pg_config.h and
set

#define INDEX_MAX_KEYS          64

to a higher value. Default is 16. I increased mine to 64 for
example. Remember that you have to re-initdb your database after setting
this value to a higher one and recompile/installing your postgresql
version.

Kind regards
... Ralph ...



pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: how to get the primary key of a freshly inserted row
Next
From: Edwin Grubbs
Date:
Subject: inet <<= and indexes