Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tWZ8Z-00HX1d-Mr for pgsql-committers@arkaria.postgresql.org; Sat, 11 Jan 2025 10:54:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tWZ8Y-008JDX-44 for pgsql-committers@arkaria.postgresql.org; Sat, 11 Jan 2025 10:54:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tWZ8X-008JDG-Rs for pgsql-committers@lists.postgresql.org; Sat, 11 Jan 2025 10:54:37 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tWZ8V-0011nY-01 for pgsql-committers@lists.postgresql.org; Sat, 11 Jan 2025 10:54:36 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tWZ8T-0033Ln-RJ for pgsql-committers@lists.postgresql.org; Sat, 11 Jan 2025 10:54:34 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tWZ8T-000yuv-3r for pgsql-committers@lists.postgresql.org; Sat, 11 Jan 2025 10:54:33 +0000 Content-Type: multipart/mixed; boundary="===============3236679886243505239==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add support for NOT ENFORCED in CHECK constraints X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 11 Jan 2025 10:54:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3236679886243505239== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHN1cHBvcnQgZm9yIE5PVCBFTkZPUkNFRCBpbiBDSEVDSyBjb25zdHJhaW50cwoKVGhpcyBh ZGRzIHN1cHBvcnQgZm9yIHRoZSBOT1QgRU5GT1JDRUQvRU5GT1JDRUQgZmxhZyBmb3IgY29uc3Ry YWludHMsCndpdGggc3VwcG9ydCBmb3IgY2hlY2sgY29uc3RyYWludHMuCgpUaGUgcGxhbiBpcyB0 byBldmVudHVhbGx5IHN1cHBvcnQgdGhpcyBmb3IgZm9yZWlnbiBrZXkgY29uc3RyYWludHMsCndo ZXJlIGl0IGlzIHR5cGljYWxseSBtb3JlIHVzZWZ1bC4KCk5vdGUgdGhhdCBDSEVDSyBjb25zdHJh aW50cyBkbyBub3QgY3VycmVudGx5IHN1cHBvcnQgQUxURVIgb3BlcmF0aW9ucywKc28gY2hhbmdp bmcgdGhlIGVuZm9yY2VhYmlsaXR5IG9mIGFuIGV4aXN0aW5nIGNvbnN0cmFpbnQgaXNuJ3QKcG9z c2libGUgd2l0aG91dCBkcm9wcGluZyBhbmQgcmVjcmVhdGluZyBpdC4gIFRoaXMgY291bGQgYmUg YWRkZWQKbGF0ZXIuCgpBdXRob3I6IEFtdWwgU3VsIDxhbXVsLnN1bEBlbnRlcnByaXNlZGIuY29t PgpSZXZpZXdlZC1ieTogUGV0ZXIgRWlzZW50cmF1dCA8cGV0ZXJAZWlzZW50cmF1dC5vcmc+ClJl dmlld2VkLWJ5OiBqaWFuIGhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ClRlc3RlZC1i eTogVHJpdmVuaSBOIDx0cml2ZW5pLm5AZW50ZXJwcmlzZWRiLmNvbT4KRGlzY3Vzc2lvbjogaHR0 cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0L0NBQUpfYjk2MmM1QWNZVzlL VXRfUl9FUjVxczNmVUdiZTRhei1TUC12dXdQUy13LUFHQUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNo Ci0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmL2NhODdjNDE1ZTJmY2NmODFjZWM2ZmQ0NTY5OGRkZTlmYWUwYWI1NzAK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21s ICAgICAgICAgICAgICAgICAgICAgIHwgIDEwICsrKwpkb2Mvc3JjL3NnbWwvaW5mb3JtYXRpb25f c2NoZW1hLnNnbWwgICAgICAgICAgICB8ICAgNCArLQpkb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3Rh YmxlLnNnbWwgICAgICAgICAgICAgICB8ICAxMiArLS0KZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVf Zm9yZWlnbl90YWJsZS5zZ21sICAgICAgfCAgIDYgKy0KZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVf dGFibGUuc2dtbCAgICAgICAgICAgICAgfCAgMzQgKysrKysrKy0Kc3JjL2JhY2tlbmQvYWNjZXNz L2NvbW1vbi90dXBkZXNjLmMgICAgICAgICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9jYXRhbG9n L2hlYXAuYyAgICAgICAgICAgICAgICAgICAgICB8ICA1NSArKysrKysrKysrLS0tCnNyYy9iYWNr ZW5kL2NhdGFsb2cvaW5kZXguYyAgICAgICAgICAgICAgICAgICAgIHwgICAxICsKc3JjL2JhY2tl bmQvY2F0YWxvZy9pbmZvcm1hdGlvbl9zY2hlbWEuc3FsICAgICAgfCAgIDIgKy0Kc3JjL2JhY2tl bmQvY2F0YWxvZy9wZ19jb25zdHJhaW50LmMgICAgICAgICAgICAgfCAgIDkgKysKc3JjL2JhY2tl bmQvY2F0YWxvZy9zcWxfZmVhdHVyZXMudHh0ICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2JhY2tl bmQvY29tbWFuZHMvdGFibGVjbWRzLmMgICAgICAgICAgICAgICAgfCAgNTEgKysrKysrKysrKyst CnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RyaWdnZXIuYyAgICAgICAgICAgICAgICAgIHwgICAxICsK c3JjL2JhY2tlbmQvY29tbWFuZHMvdHlwZWNtZHMuYyAgICAgICAgICAgICAgICAgfCAgMTcgKysr KwpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjTWFpbi5jICAgICAgICAgICAgICAgICB8ICAgOCAr LQpzcmMvYmFja2VuZC9ub2Rlcy9tYWtlZnVuY3MuYyAgICAgICAgICAgICAgICAgICB8ICAgMSAr CnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BsYW5jYXQuYyAgICAgICAgICAgIHwgIDExICsr KwpzcmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55ICAgICAgICAgICAgICAgICAgICAgICB8IDEwNCAr KysrKysrKysrKysrKysrKysrLS0tLS0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3V0aWxjbWQu YyAgICAgICAgICAgICAgfCAgNTcgKysrKysrKysrKystLQpzcmMvYmFja2VuZC91dGlscy9hZHQv cnVsZXV0aWxzLmMgICAgICAgICAgICAgICB8ICAgNiArLQpzcmMvYmFja2VuZC91dGlscy9jYWNo ZS9yZWxjYWNoZS5jICAgICAgICAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL2FjY2Vzcy90dXBk ZXNjLmggICAgICAgICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2 ZXJzaW9uLmggICAgICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9oZWFw LmggICAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX2Nv bnN0cmFpbnQuaCAgICAgICAgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9k ZXMuaCAgICAgICAgICAgICAgICAgIHwgICAzICsKc3JjL2luY2x1ZGUvcGFyc2VyL2t3bGlzdC5o ICAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Fs dGVyX3RhYmxlLm91dCAgICAgICB8ICAxMCArKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9j b25zdHJhaW50cy5vdXQgICAgICAgfCAgNDAgKysrKysrKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvY3JlYXRlX3RhYmxlX2xpa2Uub3V0IHwgIDEwICsrLQpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL2RvbWFpbi5vdXQgICAgICAgICAgICB8ICAyMiArKysrKwpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL2luaGVyaXQub3V0ICAgICAgICAgICB8ICA5NCArKysrKysrKysrKysrKysrKysr LS0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvYWx0ZXJfdGFibGUuc3FsICAgICAgICAgICAgfCAgIDcg KysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvY29uc3RyYWludHMuc3FsICAgICAgICAgICAgfCAgMjIg KysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX3RhYmxlX2xpa2Uuc3FsICAgICAgfCAg IDMgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZG9tYWluLnNxbCAgICAgICAgICAgICAgICAgfCAg MTAgKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2luaGVyaXQuc3FsICAgICAgICAgICAgICAgIHwg IDQ3ICsrKysrKysrKystCjM3IGZpbGVzIGNoYW5nZWQsIDU5OSBpbnNlcnRpb25zKCspLCA3MCBk ZWxldGlvbnMoLSkKCg== --===============3236679886243505239==--