Correction, sorry.. Doesn't survive a backup and restore.. Just double
checked.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Brenden Walker
> Sent: Tuesday, October 04, 2005 3:28 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..
>
> 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
> >
> >
> >
> >
> >
> >
> >
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Most low income households are not
> online. Help bridge the digital divide today!
> http://us.click.yahoo.com/cd_AJB/QnQLAA/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
>
>
>
>
>
>
>