Subject Re: [firebird-support] Err -663 "Too many keys defined for index" while trying to create single field index on table with 4 records..
Author Ann W. Harrison
Brenden Walker wrote:
> Certainly, it returns null... This was the only index that existed.
>
> Interesting theory though, we do re-create these indexes often enough,
> in particular during database upgrades and the like. Does the system
> remember the next id (like a generator) even if there are no indexes?
>

I probably ought to look at the code and try to figure that out. Index
definitions are kept on the index root page - and I don't remember
whether old ones are removed... nor, for that matter, do I remember how
many indexes are considered too many... the number 127 comes to mind.

Regards,


Ann