Fixed on FB1.5, where I get error:

unsuccessful metadata update
-MODIFY RDB$RELATION_FIELDS failed
-action cancelled by trigger (1) to preserve data integrity
-Cannot update index segment used by an Integrity Constraint


Ivan

----- Original Message -----
From: "Riho-Rene Ellermaa" <r.ellermaa@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, August 24, 2004 10:53 AM
Subject: [firebird-support] Alter tabel problem


> I'm using FB 1.03 in Windows 2000
> I have a table (containing about 20-30 records):
> CREATE TABLE FOR_CORRESP (
> NAME VARCHAR(35) CHARACTER SET WIN1252 NOT NULL,
>
> ACCOUNT ACCOUNT NOT NULL,
> BALCODE VARCHAR(3) CHARACTER SET WIN1252,
> COUNTRY VARCHAR(3) CHARACTER SET WIN1252,
> PRIMARY KEY (NAME,ACCOUNT)
> );
>
> When I tried to change it with:
> alter table for_corresp alter name type varchar(70);
> the ibserver.exe started to run with 90% CPU and it took 5 min to stop
> the server.
>
> Is it some server problem or shouldn't I use ALTER this way?
>
> Riho Ellermaa