updatable_statement_isolation option

Specifies the isolation level used by updatable statements when the isolation_level option is set to Readonly-statement-snapshot.

Allowed values

0, 1, 2, 3

Default

Scope

	PUBLIC role	For current user	For other users
Allowed to set permanently?	Yes, with SET ANY PUBLIC OPTION	Yes	Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily?	Yes, with SET ANY PUBLIC OPTION	Yes (current connection only)	No

Remarks

The isolation level specified by the updatable_statement_isolation option is used by updatable statements when the isolation_level option is set to Readonly-statement-snapshot. The following values are accepted:

0
Allow dirty reads, non-repeatable reads, and phantom rows.
1
Prevent dirty reads. Allow non-repeatable reads and phantom rows.
2
Prevent dirty reads and non-repeatable reads. Allow phantom rows.
3
Serializable. Prevent dirty reads, non-repeatable reads, and phantom rows.