---In [email protected], <jorge.brugger@...> wrote :
 
 > I have this table:
 > 
> CREATE TABLE TRAZABILIDAD_ERRORES (
>     CODIGO_ERROR       SMALLINT,
>     DESCRIPCION_ERROR  VARCHAR(400),
>     TIPO_ERROR         SMALLINT
> );
> 
 > When I try to add a PK:
> ALTER TABLE TRAZABILIDAD_ERRORES
> ADD CONSTRAINT PK_TRAZABILIDAD_ERRORES
> PRIMARY KEY (CODIGO_ERROR);
> 
 > I get:
> unsuccessful metadata update.
> ALTER TABLE TRAZABILIDAD_ERRORES failed.

 > unknown ISC error 336068731.

 

   This is:

 

 Column: @1 not defined as NOT NULL - cannot be used in PRIMARY KEY constraint 
definition

 

 Looks like you have wrong Firebird client\message file

 

> It´s "fixable"?

  

 Sure. PK columns must be defined as NOT NULL
 

 Regards,
 Vlad



Reply via email to