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
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
当前内容版权归 YugabyteDB 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 YugabyteDB .