Subject | Re: [firebird-support] Does 2.0.3.12981 version requires smaller instead or bigger index keys? ref/eDN6063215442 |
---|---|
Author | Vlad Khorsun |
Post date | 2007-12-12T09:53:21Z |
> I was working with version 2.0.0.12748 and now with version 2.0.3.12981 theWhat is ODS and page size of your database ? (gstat -h will tell you)
> follow index cannot be creatred:
>
> CREATE INDEX CODES_IDX2 ON CODES (KEY_, RES_);
>
>
>
> The error message is:
>
> This operation is not defined for system tables.
>
> unsuccessful metadata update.
>
> key size exceeds implementation restriction for index "CODES_IDX2".
>
>
>
> Key_ and res_ fields are varchar(100),
>
>
>
> Character set: DEFAULT CHARACTER SET NONE
>
>
>
> What happen? Does 2.0.3.12981 version requires smaller instead or bigger
> index keys? Where am I wrong?
Regards,
Vlad