Setting Isolation Levels

PostgreSQL supports two levels of settings for transaction isolations levels, one at the session level via the SQL statement "set session characteristics as transaction isolation level " and the other at the transaction level via the SQL statement "set transaction".

The method isolation()of class RWDBConnection sets the session isolation level. The following table shows the mapping between the argument you pass for IsolationType, and the isolation level set by the PostgreSQL Access Module.

Setting the isolation level

RWDBConnection:: IsolationType	PostgreSQL Isolation Level
Unknown	(not supported by PostgreSQL)
ANSILevel1	read committed
ANSILevel2	(not supported by PostgreSQL)
ANSILevel3	serializable

To determine the current isolation level, call RWDBConnection::isolation() without an argument.