informix 建立主键报550错误

碧咸最帅

建表语句如下：
create table ob_credit_job
(
  task_id varchar( 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.
请问该如何解决？谢谢

liaosnet

建表语句如下：
create table ob_credit_job
(
  task_id varchar( not null ,
  jobid varchar(255) ...
碧咸最帅 发表于 2010-03-26 16:12

   
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.

antyison

没遇到过这个情况。。。

-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.