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. Table 5 shows the mapping between the argument you pass for IsolationType, and the isolation level set by the PostgreSQL Access Module.

Table 247. 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.