I forgot to mention that this corruption seems to survive a backup and
restore, which I think is very very odd.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Brenden Walker
> Sent: Tuesday, October 04, 2005 2:15 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Err -663 "Too many keys defined
> for index" while trying to create single field index on table
> with 4 records..
>
> I'm not sure what gives, somehow we've got a database in a
> state where we cannot re-create an index on a table. If I
> drop and re-add the table everything works fine. I tried
> searching the bug tracker on source forge with no luck.
>
> I can remove all the data, still can't create the index.
> Just for clarity's sake, here's the table DDL:
>
>
> CREATE TABLE REP_PARSEDLOGS (
> CHANGEID INTEGER,
> LOGDATE DATE,
> TABLENAME CHAR(32),
> CLASSID SMALLINT,
> CHANGETYPE CHAR(1),
> FIELDNAMES VARCHAR(1024),
> FIELDVALUES VARCHAR(8192)
> );
>
>
> And here's the index I'm trying to create: create unique
> index primary_parsedlogs on rep_parsedlogs(ChangeID)
>
> I know this is proper syntax, and works fine normally.. It
> just there's something very specific wrong with this database
> and I'm trying to figure out how/why it got that way.
>
> Anyone ever heard of anything like this? This is a FB 1.5.2 database.
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Fair play? Video games influencing
> politics. Click and talk back!
> http://us.click.yahoo.com/T8sf5C/tzNLAA/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
>
>
>
>
>
>
>