| Subject | Re: [firebird-support] Trying to drop an index |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-10-26T12:37:33Z |
At 02:16 PM 26/10/2005 +0200, you wrote:
do this?
Check for other transactions still running, involving the table that the
index belongs to, and either commit them or roll them back.
If, on the other hand, the index is a constraint index, you can't drop
it. You'll have to find the name of the constraint and drop that.
./heLen
>We are trying to drop an index and we get an object is in use error. We areIs this "the Royal We" or are there actually more than one of you trying to
>certain that there are no other connections open to the database and yet we
>get this error. Is there a special trick or something?
do this?
Check for other transactions still running, involving the table that the
index belongs to, and either commit them or roll them back.
If, on the other hand, the index is a constraint index, you can't drop
it. You'll have to find the name of the constraint and drop that.
./heLen