Subject Re: [firebird-support] too many keys defined for index
Author Helen Borrie
At 09:27 PM 26/02/2004 -0300, you wrote:
>Hi,
>
>What means the following message ?
>
>---
>
>ISC ERROR CODE:335544351
>
>ISC ERROR MESSAGE:
>unsuccessful metadata update
>too many keys defined for index BSTRM_TRM
>
>Statement: CREATE INDEX BSTRM_TRM ON BSTRM (TRM)
>
>---
>
>DDL of this table:
>
>---
>
>CREATE TABLE BSTRM (
> COD INTEGER NOT NULL,
> TRM VARCHAR(128) NOT NULL);

Best guess is that you do have an error (the size of the column is too many
bytes for the 253-byte limit) but you have the wrong message file in your
setup somewhere (at server or client).

If this is character set UNICODE_FSS your character limit for indexes is
very low, about 84 characters, or less for multi-column indexes.

/heLen