We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
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.
The text was updated successfully, but these errors were encountered:
Commented by: Sean Leyne (seanleyne)
What is the character set of the database?
What is the page size of the database?
Sorry, something went wrong.
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?
No branches or pull requests
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.
The text was updated successfully, but these errors were encountered: