Hello,

I have a datamodel designed for Oracle 8i and I am migrating it to
Interbase 6 (running on LinuX/OS -based on RedHat 6.0) ... I have a
table, for example, that has the following structure:

create table t_UserGroupActionRoleMap (
iGroupID integer not null references t_UserGroups(iGroupID),
sRole varchar(200) not null,
sAction varchar(200) not null,
dCreationDate timestamp not null,
iCreationUser integer not null references t_Users(iUserID),
sCreationIpAddress varchar(50) not null,
primary key (iGroupID, sRole)
);

Don't worry about the foreign keys and such... When trying to execute
this from the ISQL window, I get the following error message:

--- START isql error message

unsuccessful metadata update
key size too big for index RDB$PRIMARY115
Statement: create table t_UserGroupActionRoleMap ( iGroupID
integer not null references t_UserGroups(iGroupID), sRole
varchar(200) not null, sAction varchar(200)
not null, dCreationDate timestamp not null, iCreationUser
integer not null references t_Users(iUserID),
sCreationIpAddress varchar(50) not null, primary key (iGroupID,
sRole) )

--- END message from ISQL

Is there a limit on the size of the columns that made part of the
primary key?

Thanks in advance... ah! and excuse my question but I have looked
through all the documentation and couldn't find any reference for the
key size ...

/B