Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

key size exceeds implementation restriction [CORE3499] #3858

Closed
firebird-automations opened this issue May 27, 2011 · 2 comments
Closed

key size exceeds implementation restriction [CORE3499] #3858

firebird-automations opened this issue May 27, 2011 · 2 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Dieter Blume (blume-edv)

When using Firebird 2.5, the following error occurs:

Unsuccessful metadata update
key size exceeds implementation restriction for index "RDB$PRIMARY23"
Statement:

CREATE TABLE OBD (OBJEKT VARCHAR(20) NOT NULL,
DATEI VARCHAR(180) NOT NULL,
USRINS VARCHAR(8) NOT NULL,
DATINS TIMESTAMP NOT NULL,
USRUPD VARCHAR(8),
DATUPD TIMESTAMP,
TSTAMP TIMESTAMP NOT NULL,
ZUSINFO VARCHAR(40),
FOREIGN KEY (OBJEKT) REFERENCES OBJ,
PRIMARY KEY (OBJEKT,DATEI))

The same statement works fine under firebird 1.5.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

What is the character set of the database?

What is the page size of the database?

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

One more question - what is the ODS of the database? I.e. did you perform backup on 1.5 and restore on 2.5 or just opened 1.5 database file with 2.5?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants