Subject Re: [ib-support] key size too small
Author Helen Borrie
At 11:15 AM 6/03/2003 +0200, you wrote:
>I need to create an unique check on a table:
>alter table GROUPS
>add constraint UNIQUE_GROUP
>unique ([NAME1], [NAME2])
>This operation is not defined for system tables.
>unsuccessful metadata update.
>key size too big for index UNIQUE_GROUP.

You have used wrong syntax and you are getting an approximate evaluation of
an unknown error. (Because of the square brackets, your syntax is trying
to create an index from two non-existent array columns, sort-of).

Correct syntax is
alter table GROUPS
add constraint UNIQUE_GROUP
unique (NAME1, NAME2)