khooc
asked on
Create Unique Index comes up with "Key size too big" error
This is the statement I'm trying to run on a Firebird database:
CREATE UNIQUE INDEX "iName_Software" ON "Software"("Name");
Unfortunately, it comes up with this error:
This operation is not defined for system tables. Unsuccessful metadata update.
Key size too big for index iName_Software
Anyone with ideas on why this occurs? I would've thought this would be fairly standard.
CREATE UNIQUE INDEX "iName_Software" ON "Software"("Name");
Unfortunately, it comes up with this error:
This operation is not defined for system tables. Unsuccessful metadata update.
Key size too big for index iName_Software
Anyone with ideas on why this occurs? I would've thought this would be fairly standard.
please tell us your table structure and character set, also which version of firebird
ASKER
Hi Nick
Firebird Version: 1.5.3.4870
Charset: NONE
For Table structure, name is Software.
Fields are:
- OID INTEGER - Primary Key
- "Name" VARCHAR(100)
Does that help?
BTW kacor, I tried your suggestion - it doesn't work.
Chris
Firebird Version: 1.5.3.4870
Charset: NONE
For Table structure, name is Software.
Fields are:
- OID INTEGER - Primary Key
- "Name" VARCHAR(100)
Does that help?
BTW kacor, I tried your suggestion - it doesn't work.
Chris
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hmmm
as per http://www.ibphoenix.com/main.nfs?page=ibp_expert1
I decided to upgrade to 2.0 RC2 and I could create the index.
Hopefully it isn't too long until 2.0 is deemed production ready...
as per http://www.ibphoenix.com/main.nfs?page=ibp_expert1
I decided to upgrade to 2.0 RC2 and I could create the index.
Hopefully it isn't too long until 2.0 is deemed production ready...
NB RC3 came out today
ASKER
BTW thanks for your help Nick - your answer was the best.
Chris
Chris
CREATE UNIQUE INDEX iName_Software ON Software(Name);
Janos