| 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 | Brenden Walker |
| Post date | 2005-10-05T12:09:53Z |
> -----Original Message-----Should I perhaps post this to the Dev list and see if someone wants the
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
> Sent: Tuesday, October 04, 2005 5:28 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Err -663 "Too many keys
> defined for index" while trying to create single field index
> on table with 4 records..
>
> 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.
affected database for testing?