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?

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
> Sent: Tuesday, October 04, 2005 4:48 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,
>
> 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
>
>
>
> ------------------------ 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
>
>
>
>
>
>
>