informix 建立主键报550错误
建表语句如下：create table ob_credit_job
(
task_id varchar(8) not null ,
jobid varchar(255) not null ,
primary key (task_id,jobid)
);
revoke all on ob_credit_job from "public";
执行后报错：
550: Total length of columns in constraint is too long.
请问该如何解决？谢谢 建表语句如下：
create table ob_credit_job
(
task_id varchar( not null ,
jobid varchar(255) ...
碧咸最帅 发表于 2010-03-26 16:12 http://bbs2.chinaunix.net/images/common/back.gif
Total length of columns in constraint is too long.
The total size of all the columns listed in a UNIQUE, PRIMARY KEY, or FOREIGN KEY clause is limited. The limit is the same as the restriction on the total size of all columns in a composite index. IBM Informix Dynamic Server allows 16 key parts and a width of 390 bytes on a 2K page platform. On 4K page platforms or using a non-default page size allows greater than 390 bytes for the width of indexed columns. IBM Informix SE supports 8 columns and a width of 126 bytes. Other Informix database servers allow 16 columns and 255 bytes. The limit depends on the database server in use, but all servers support a total of at least 120 bytes.
For additional information, see the CREATE TABLE statement in the IBM Informix Guide to SQL: Syntax. 没遇到过这个情况。。。
-550 在约束中的字段总长太长。
列在 UNIQUE、PRIMARY KEY 或者FOREIGN KEY 子句中的所有字段的总长是有限
的。这个限制取决于使用的数据库服务器，而所有的服务器至少支持 120 字节的总长。
这个限制，和复合索引中的所有字段总长的限制是一样的。更详细的信息，请参阅
《Informix SQL 指南：语法》中CREATE TABLE 语句。
-550
--------------------------------------------------------------------------------
Total length of columns in constraint is too long.
The total size of all the columns listed in a UNIQUE, PRIMARY KEY, or FOREIGN KEY clause is limited. The limit is the same as the restriction on the total size of all columns in a composite index. IBM Informix Dynamic Server allows 16 key parts and a width of 390 bytes on a 2K page platform. On 4K page platforms or using a non-default page size allows greater than 390 bytes for the width of indexed columns. IBM Informix SE supports 8 columns and a width of 126 bytes. Other Informix database servers allow 16 columns and 255 bytes. The limit depends on the database server in use, but all servers support a total of at least 120 bytes.
For additional information, see the CREATE TABLE statement in the IBM Informix Guide to SQL: Syntax.
页:
[1]