Subject Re: unsuccessful metadata update, key size too big for index
Author h_urlaf
--- In firebird-support@yahoogroups.com, "Martijn Tonies"

> > When I try to create this table, I get the error
> > "unsuccessful metadata update, key size too big for index"
>
> From looking at the above DDL, I can't say that I think the
> keysize would be too big.

That's what I figured, but the error is there nonetheless.

> What default characterset does this database have?

UNICODE_FSS

> > 1. Break up this table into multiple tables, tie them together
> > with foreign keys, and enforce uniqueness in each separate table.
> > A view could be used to bring them together.
>
> I have no idea why this should help.

I figured that each table would only have two constraints max.

Thanks,
Emiliano