Re: Cannot use more than 16 attributes in an index

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Cannot use more than 16 attributes in an index
Дата
Msg-id 20020806114204.I85827-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Cannot use more than 16 attributes in an index  ("Thomas Bolden" <tbolden@mail.state.mo.us>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Cédric Dufour
Дата:
Сообщение: Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Primary Key: How Do I Generate One For Insert ...