I run the following SQL before updating one table:
"lock table tablename"
but when I try do update the same table later on, the lock table command just hangs (i.e the table is already locked). It was my understanding that this lock was removed when I call commit or do I have to explicitly unlock the table somehow?
