Guten Tag Kjell Rilbe,

what happens if you commit after alter table ?

> Hi,

> This seems buggy to me (Firebird WI-V2.5.2.26540 64 bit):

> create table "Test" ("MyCol" int);
> create index "IxTest" on "Test" ("MyCol");
> [commit]

> alter table "Test" alter "MyCol" to "NewName";
> drop index "IxTest";
> [commit]

> In FlameRobin, this results in error message:
> ======================================
> *** IBPP::SQLException ***
> Context: Transaction::Commit

> SQL Message : -607
> This operation is not defined for system tables.

> Engine Code : 335544351
> Engine Message :
> unsuccessful metadata update
> cannot create index IxTest
> ======================================

> After that, the index seems to be in use preventing me from doing
> "anything", until I disconnect and reconnect.

> If I drop the index before renaming the column, it works as expected.

--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...