key size exceeds implementation restriction
-------------------------------------------

                 Key: CORE-3499
                 URL: http://tracker.firebirdsql.org/browse/CORE-3499
             Project: Firebird Core
          Issue Type: Bug
    Affects Versions: 2.5.0
            Reporter: Dieter Blume


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery, 
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now. 
http://p.sf.net/sfu/quest-d2dcopy1
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to