> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Brenden Walker
> Sent: Wednesday, October 05, 2005 8:10 AM
> 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..
>
> > -----Original Message-----

<snip>

> > 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.
>
> Should I perhaps post this to the Dev list and see if someone
> wants the affected database for testing?

Some additional information. Just out of curiousity I deleted
everything from the database except the effected table (all generators,
tables, view, UDF's, procedures, etc). Then I swept the database.
After doing that I was able to create the index in question.