Re: Cannot use more than 16 attributes in an index

From: Ralph Graulich <maillist(at)shauny(dot)de>
To: Thomas Bolden <tbolden(at)mail(dot)state(dot)mo(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot use more than 16 attributes in an index
Date: 2002-08-06 19:07:44
Message-ID: Pine.LNX.4.21.0208062106200.25616-100000@shauny.shauny.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2002-08-06 19:08:38 Re: View the contents of a database
Previous Message Richard Huxton 2002-08-06 19:07:02 Re: Cannot use more than 16 attributes in an index