Subject Re[2]: [ib-support] Unsuccessful metatdata update: Index is in use
Author Ann W. Harrison
At 09:15 AM 3/25/2002 +0100, Dieter Tremel wrote:

>Unfortunately I understood not perfectly why the index remains locked
>even if the transaction is committed. Is this a bug or necessary?

Necessary. Prepared statements are preserved across commits,
and usually reference indexes. Deleting an index that is used
in a prepared statement will lead to any ugly end if that statement
is reused.


We have answers.