Horton

Add support for NOT ENFORCED in CHECK constraints

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: ca87c415e2fccf81cec6fd45698dde9fae0ab570
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2025-01-11T09:52:30Z
Releases: 18.0 
Add support for NOT ENFORCED in CHECK constraints

This adds support for the NOT ENFORCED/ENFORCED flag for constraints,
with support for check constraints.

The plan is to eventually support this for foreign key constraints,
where it is typically more useful.

Note that CHECK constraints do not currently support ALTER operations,
so changing the enforceability of an existing constraint isn't
possible without dropping and recreating it.  This could be added
later.

Author: Amul Sul <amul.sul@enterprisedb.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Reviewed-by: jian he <jian.universality@gmail.com>
Tested-by: Triveni N <triveni.n@enterprisedb.com>
Discussion: https://www.postgresql.org/message-id/flat/CAAJ_b962c5AcYW9KUt_R_ER5qs3fUGbe4az-SP-vuwPS-w-AGA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +10 −0
doc/src/sgml/information_schema.sgml modified +1 −3
doc/src/sgml/ref/alter_table.sgml modified +7 −5
doc/src/sgml/ref/create_foreign_table.sgml modified +4 −2
doc/src/sgml/ref/create_table.sgml modified +32 −2
src/backend/access/common/tupdesc.c modified +2 −0
src/backend/catalog/heap.c modified +45 −10
src/backend/catalog/index.c modified +1 −0
src/backend/catalog/information_schema.sql modified +1 −1
src/backend/catalog/pg_constraint.c modified +9 −0
src/backend/catalog/sql_features.txt modified +1 −1
src/backend/commands/tablecmds.c modified +47 −4
src/backend/commands/trigger.c modified +1 −0
src/backend/commands/typecmds.c modified +17 −0
src/backend/executor/execMain.c modified +6 −2
src/backend/nodes/makefuncs.c modified +1 −0
src/backend/optimizer/util/plancat.c modified +11 −0
src/backend/parser/gram.y modified +84 −20
src/backend/parser/parse_utilcmd.c modified +52 −5
src/backend/utils/adt/ruleutils.c modified +5 −1
src/backend/utils/cache/relcache.c modified +1 −0
src/include/access/tupdesc.h modified +1 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/heap.h modified +1 −0
src/include/catalog/pg_constraint.h modified +2 −0
src/include/nodes/parsenodes.h modified +3 −0
src/include/parser/kwlist.h modified +1 −0
src/test/regress/expected/alter_table.out modified +10 −0
src/test/regress/expected/constraints.out modified +39 −1
src/test/regress/expected/create_table_like.out modified +9 −1
src/test/regress/expected/domain.out modified +22 −0
src/test/regress/expected/inherit.out modified +86 −8
src/test/regress/sql/alter_table.sql modified +7 −0
src/test/regress/sql/constraints.sql modified +21 −1
src/test/regress/sql/create_table_like.sql modified +2 −1
src/test/regress/sql/domain.sql modified +10 −0
src/test/regress/sql/inherit.sql modified +46 −1

Documentation touched

Discussion