diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2025-01-11 10:45:17 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2025-01-11 10:52:30 +0100 |
| commit | ca87c415e2fccf81cec6fd45698dde9fae0ab570 (patch) | |
| tree | f9e1f5fc7637f0baf91566f4d8a333ddb60960b1 /src/backend/nodes/makefuncs.c | |
| parent | 72ceb21b029433dd82f29182894dce63e639b4d4 (diff) | |
| download | postgresql-ca87c415e2fccf81cec6fd45698dde9fae0ab570.tar.gz postgresql-ca87c415e2fccf81cec6fd45698dde9fae0ab570.zip | |
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
Diffstat (limited to 'src/backend/nodes/makefuncs.c')
| -rw-r--r-- | src/backend/nodes/makefuncs.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/backend/nodes/makefuncs.c b/src/backend/nodes/makefuncs.c index 6b66bc18286..b14d4d6adf4 100644 --- a/src/backend/nodes/makefuncs.c +++ b/src/backend/nodes/makefuncs.c @@ -453,6 +453,7 @@ makeNotNullConstraint(String *colname) notnull->initdeferred = false; notnull->location = -1; notnull->keys = list_make1(colname); + notnull->is_enforced = true; notnull->skip_validation = false; notnull->initially_valid = true; |