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 5 – 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.
