Subject RE: [firebird-support] Alter tabel problem
Author Riho-Rene Ellermaa
I know it's not correct, but just tried to see what happens (now I know
I let the server run 5 min, then opened FB Manager and pressed Stop.
After another 5 min or so the server stopped with I/O overlapped error.
The database is very small and I assumed that if it took 5 min with
full power to do nothing, then the server is probably running inside
some loop.

Riho Ellermaa

> >or shouldn't I use ALTER this way?
> Next time, you'll probably decide to drop the primary key
> constraint first. Or, if you're using keys that are so
> unstable, you might even decide to do something creative like
> surrogating them with artificial keys.
> Call it "a learning experience".
> Do you always try to express your feelings about slow
> operations by killing the server? If so, that might become a
> learning experience for you some day, too...
> ./heLen