Antti Linno <alligator@all.ee> writes:
> Is there any possibility to unlock tables after they've been locked? The
> manual part of lock was fuzzy, so I ask from experts instead. MySQL
> uses lock and unlock.
Locks are released at transaction commit/abort. It has to be that way
to preserve transaction semantics. I'll refrain from commenting about
MySQL's transaction support...
regards, tom lane