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-04T20:47:40Z |
Brenden,
When your database is in the state where it's returning the error,
would you try
select max (rdb$index_id) from rdb$indices
where rdb$relation_name = 'REP_PARSEDLOGS';
I suspect that we're returning the wrong message and that the problem is
that - over time - you've used as many index definitions for that table
as the system considers sane...
Regards,
Ann
When your database is in the state where it's returning the error,
would you try
select max (rdb$index_id) from rdb$indices
where rdb$relation_name = 'REP_PARSEDLOGS';
I suspect that we're returning the wrong message and that the problem is
that - over time - you've used as many index definitions for that table
as the system considers sane...
Regards,
Ann