Hi!

I get quite a strange error message with Firebird 1.0 when creating a
database:

unsuccessful metadata update
key size exceeds implementation restriction for index
"Person_PersName_Idx"
index Entry_Actor_Idx cannot be used in the specified plan.

Some background:

Table Person
(PersonID Numeric(18,0) = Primary Key,
PersName VarChar(70) collate DE_DE (with ISO8859_1),
....)

Person_PersName_Idx = Index(PersName, PersonID)

index Entry_Actor_Idx = Numeric(18), Date, Numeric(18) of a table Entry.

I use this index in a plan of a stored procedure - but this stored
procedure is not related to table person nor Person_PersName_Idx.

The error occured when I extended PersName from 60 to 70.

Has anyone a clue what the cause about this error? I know of the
limitation for indexes of 255 characters but as I can see that
shoudn't be a problem for the situation above.

Thanks for any help!
Daniel