BLOCKING Option

Controls the behavior in response to locking conflicts.

Allowed Values

OFF

Default

OFF

Scope

Can be set for an individual connection or the PUBLIC group. Takes effect immediately.

Description

When BLOCKING is OFF, a transaction receives an error when it attempts a write operation and is blocked by the read lock of another transaction.