Re: Cannot use more than 16 attributes in an index
От | John Gray |
---|---|
Тема | Re: Cannot use more than 16 attributes in an index |
Дата | |
Msg-id | 1028659824.3943.44.camel@adzuki обсуждение исходный текст |
Ответ на | Cannot use more than 16 attributes in an index ("Thomas Bolden" <tbolden@mail.state.mo.us>) |
Список | pgsql-general |
On Tue, 2002-08-06 at 16:43, 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 toincrease this limit. > I have installed Ver 7.2.1 Postgresql on FreeBSD 4.6. This is fairly straightforward. Assuming that you are building from source, alter the definition of INDEX_MAX_KEYS in src/include/pg_config.h.in i.e. #define INDEX_MAX_KEYS 32 ...and recompile. Note that you will have to use initdb again to rebuild your database cluster, so be sure to dump any data that you want to keep from the database. There is no problem (other than a minor performance penalty) associated with changing this definition.(It is quite possible that it will be raised to 32 anyway in version 7.3) If this isn't clear, get back in touch and someone will give clearer instructions! Regards John -- John Gray Azuli IT www.azuli.co.uk
В списке pgsql-general по дате отправления: