Fred Toussi - 2011-05-04

Good idea especially in MVCC.

For the default LOCKS concurrency model, there is a simple method when you are using the READ COMMITTED isolation level:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
LOCK TABLES a READ, b READ ...
... perform transaction
COMMIT

The isolation level now goes back to the default READ COMMITTED level.