Link to home
Start Free TrialLog in
Avatar of khooc
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.
Avatar of kacor
kacor
Flag of Hungary image

Try without " eg.
CREATE UNIQUE INDEX iName_Software ON Software(Name);

Janos
Avatar of Nick Upson
please tell us your table structure and character set, also which version of firebird
Avatar of khooc
khooc

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
ASKER CERTIFIED SOLUTION
Avatar of Nick Upson
Nick Upson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of khooc

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...
NB RC3 came out today
Avatar of khooc

ASKER

BTW thanks for your help Nick - your answer was the best.

Chris