Re: [SQL] Opposite of LOCK

2000-07-12 Thread Tom Lane
Antti Linno <[EMAIL PROTECTED]> 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 trans

Re: [SQL] Opposite of LOCK

2000-07-12 Thread Jan Wieck
Antti Linno wrote: > 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. Yes, COMMIT/ROLLBACK. The transactional concept implies that you hold each lock you accquired si