Re: drop table and locks

In <8916@emory.mathcs.emory.edu> mm@ssf.pt (Manuel Monteiro) writes: >We have detected a problem when droping a table (temporary or not) or an >index in a database without transactions. >When someone drops a Table or an Index, the program leaves a lock on the table. >This is particulary serious when dropping a table, because the lock >remains on a table that no longer exists. >In this situation, if another user try to create a temporary table >(implicitly or explicitly), there is a high probability to be blocked >on that lock. >MM This seems to be similar with a problem I had; when the database had no transactions it conflicted temp tables, but I never found out if it were a locking problem, only that the problem went away when I started to log the base. I gave Colonel Panic all my information on that one, so Informix could be digesting it. Gaukur.