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 |
Post date | 2005-10-04T21:28:23Z |
Brenden Walker wrote:
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
> Certainly, it returns null... This was the only index that existed.I probably ought to look at the code and try to figure that out. Index
>
> 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?
>
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