diff options
Diffstat (limited to 'src/backend/utils/adt/ruleutils.c')
| -rw-r--r-- | src/backend/utils/adt/ruleutils.c | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c index 2089b52d575..16d15f9efb9 100644 --- a/src/backend/utils/adt/ruleutils.c +++ b/src/backend/utils/adt/ruleutils.c @@ -2591,7 +2591,11 @@ pg_get_constraintdef_worker(Oid constraintId, bool fullCommand, appendStringInfoString(&buf, " DEFERRABLE"); if (conForm->condeferred) appendStringInfoString(&buf, " INITIALLY DEFERRED"); - if (!conForm->convalidated) + + /* Validated status is irrelevant when the constraint is NOT ENFORCED. */ + if (!conForm->conenforced) + appendStringInfoString(&buf, " NOT ENFORCED"); + else if (!conForm->convalidated) appendStringInfoString(&buf, " NOT VALID"); /* Cleanup */ |