Subject Re:
Author
---In firebird-support@yahoogroups.com, <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