Re: Cannot use more than 16 attributes in an index

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
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 18:44:07
Message-ID: 20020806114204.I85827-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 to increase this limit.

ISTM you should be able to increase INDEX_MAX_KEYS in pg_config and
recompile (but I haven't tried) and re-initdb.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-08-06 18:46:24 Re: Primary Key: How Do I Generate One For Insert ...
Previous Message scott.marlowe 2002-08-06 18:41:05 Re: older version