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.



Regards,

Ann
www.ibphoenix.com
We have answers.