Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephan Szabo
Subject Re: Cannot use more than 16 attributes in an index
Date
Msg-id 20020806114204.I85827-100000@megazone23.bigpanda.com
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
Tree view 
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.

pgsql-general by date:

Previous
From: Cédric Dufour
Date:
Subject: Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR
Next
From: Stephan Szabo
Date:
Subject: Re: Primary Key: How Do I Generate One For Insert ...