Subject | RE: [firebird-support] Alter tabel problem |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2004-08-24T09:28:19Z |
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
:)
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