| 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-05T19:28:07Z |
The DB is 61.5MB. (zipps up to roughly 7.5mb, I can post to an ftp
server of course).
Just did some further testing:
- Dropped all the views, disconnected and reconnected and strangly
enough I could now create that index with no trouble at all.
- Reset test, this time dropped a single view.. Created index fine.
- Reset test, tried creating the index same 'too many keys' error (just
to be sure I had the right DB)
- Reset test, dropped all generators, (reconnect in between) unable to
create the index.
- Reset test, dropped a stored procedure.. Unable to create index.
- Dropped all stored procedures, unable to create index.
- Dropped several UDF's (many views have dependancies on these UDF's),
unable to create index.
- Reset test, dropped a single table.. Index created fine.
server of course).
Just did some further testing:
- Dropped all the views, disconnected and reconnected and strangly
enough I could now create that index with no trouble at all.
- Reset test, this time dropped a single view.. Created index fine.
- Reset test, tried creating the index same 'too many keys' error (just
to be sure I had the right DB)
- Reset test, dropped all generators, (reconnect in between) unable to
create the index.
- Reset test, dropped a stored procedure.. Unable to create index.
- Dropped all stored procedures, unable to create index.
- Dropped several UDF's (many views have dependancies on these UDF's),
unable to create index.
- Reset test, dropped a single table.. Index created fine.
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
> Sent: Wednesday, October 05, 2005 1:19 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:
> >
> >
> > 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.
>
> Oh, how odd. If you just delete stuff without sweeping, do
> you still get the error? How big is the database?
>
> Regards,
>
>
> Ann
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Get Bzzzy! (real tools to help you
> find a job). Welcome to the Sweet Life.
> http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>