[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1053
  • Last Modified:

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.
0
khooc
Asked:
khooc
  • 3
  • 3
1 Solution
 
kacorretiredCommented:
Try without " eg.
CREATE UNIQUE INDEX iName_Software ON Software(Name);

Janos
0
 
Nick UpsonPrincipal Operations EngineerCommented:
please tell us your table structure and character set, also which version of firebird
0
 
khoocAuthor Commented:
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
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Nick UpsonPrincipal Operations EngineerCommented:
Try this http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm

(please report back your findings)
0
 
khoocAuthor Commented:
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...
0
 
Nick UpsonPrincipal Operations EngineerCommented:
NB RC3 came out today
0
 
khoocAuthor Commented:
BTW thanks for your help Nick - your answer was the best.

Chris
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now