v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

SET CONSTRAINTS

Synopsis

Use the SET CONSTRAINTS statement to set the timing of constraint checking within the current transaction.

Syntax

set_constraints ::= SET CONSTRAINTS { ALL | name [ , ... ] } 
                    { DEFERRED | IMMEDIATE }

set_constraints

SETCONSTRAINTSALL,nameDEFERREDIMMEDIATE

Semantics

Attributes in the SET CONSTRAINTS statement comply with the behavior defined in the SQL standard, except that it does not apply to NOT NULL and CHECK constraints.

set_constraints

SET CONSTRAINTS { ALL | *name [ , ... ] } { DEFERRED | IMMEDIATE }

ALL

Change the mode of all deferrable constraints.

name

Specify one or a list of constraint names.

DEFERRED

Set constraints to not be checked until transaction commit.

Uniqueness and exclusion constraints are checked immediately, unless marked DEFERRABLE.

IMMEDIATE

Set constraints to take effect retroactively.

See also