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 1tzwW9-008wAo-3R for pgsql-committers@arkaria.postgresql.org; Wed, 02 Apr 2025 11:44:25 +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 1tzwW7-00CoKh-03 for pgsql-committers@arkaria.postgresql.org; Wed, 02 Apr 2025 11:44:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tzwW6-00CoKZ-Ot for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 11:44:22 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tzwW4-002xTy-0z for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 11:44:22 +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 1tzwW2-00GetE-BP for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 11:44:18 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tzwW2-002HaO-0C for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 11:44:18 +0000 Content-Type: multipart/mixed; boundary="===============2803646975087003017==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add support for NOT ENFORCED in foreign key constraints X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 02 Apr 2025 11:44:18 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2803646975087003017== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHN1cHBvcnQgZm9yIE5PVCBFTkZPUkNFRCBpbiBmb3JlaWduIGtleSBjb25zdHJhaW50cwoK VGhpcyBleHBhbmRzIHRoZSBOT1QgRU5GT1JDRUQgY29uc3RyYWludCBmbGFnLCBwcmV2aW91c2x5 IG9ubHkKc3VwcG9ydGVkIGZvciBDSEVDSyBjb25zdHJhaW50cyAoY29tbWl0IGNhODdjNDE1ZTJm KSwgdG8gZm9yZWlnbiBrZXkKY29uc3RyYWludHMuCgpOb3JtYWxseSwgd2hlbiBhIGZvcmVpZ24g a2V5IGNvbnN0cmFpbnQgaXMgY3JlYXRlZCBvbiBhIHRhYmxlLCBhY3Rpb24KYW5kIGNoZWNrIHRy aWdnZXJzIGFyZSBhZGRlZCB0byBtYWludGFpbiBkYXRhIGludGVncml0eS4gIFdpdGggdGhpcwpw YXRjaCwgaWYgYSBjb25zdHJhaW50IGlzIG1hcmtlZCBhcyBOT1QgRU5GT1JDRUQsIGludGVncml0 eSBjaGVja3MgYXJlCm5vIGxvbmdlciByZXF1aXJlZCwgbWFraW5nIHRoZXNlIHRyaWdnZXJzIHVu bmVjZXNzYXJ5LiAgQ29uc2VxdWVudGx5LAp3aGVuIGNyZWF0aW5nIGEgTk9UIEVORk9SQ0VEIGZv cmVpZ24ga2V5IGNvbnN0cmFpbnQsIHRyaWdnZXJzIHdpbGwgbm90CmJlIGNyZWF0ZWQsIGFuZCB0 aGUgY29uc3RyYWludCB3aWxsIGJlIG1hcmtlZCBhcyBOT1QgVkFMSUQuClNpbWlsYXJseSwgaWYg YW4gZXhpc3RpbmcgZm9yZWlnbiBrZXkgY29uc3RyYWludCBpcyBjaGFuZ2VkIHRvIE5PVApFTkZP UkNFRCwgdGhlIGFzc29jaWF0ZWQgdHJpZ2dlcnMgd2lsbCBiZSBkcm9wcGVkLCBhbmQgdGhlIGNv bnN0cmFpbnQKd2lsbCBhbHNvIGJlIG1hcmtlZCBhcyBOT1QgVkFMSUQuICBDb252ZXJzZWx5LCBp ZiBhIE5PVCBFTkZPUkNFRApmb3JlaWduIGtleSBjb25zdHJhaW50IGlzIGNoYW5nZWQgdG8gRU5G T1JDRUQsIHRoZSBuZWNlc3NhcnkgdHJpZ2dlcnMKd2lsbCBiZSBjcmVhdGVkLCBhbmQgdGhlIHdp bGwgYmUgY2hhbmdlZCB0byBWQUxJRCBieSBwZXJmb3JtaW5nCm5lY2Vzc2FyeSB2YWxpZGF0aW9u LgoKU2luY2Ugbm90LWVuZm9yY2VkIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnRzIGhhdmUgbm8gdHJp Z2dlcnMsIHRoZQpzaG9ydGN1dCB1c2VkIGZvciBleGFtcGxlIGluIHBzcWwgYW5kIHBnX2R1bXAg dG8gc2tpcCBsb29raW5nIGZvcgpmb3JlaWduIGtleXMgaWYgdGhlIHJlbGF0aW9uIGlzIGtub3du IG5vdCB0byBoYXZlIHRyaWdnZXJzIG5vIGxvbmdlcgphcHBsaWVzLiAgKEl0IGFscmVhZHkgZGlk bid0IHdvcmsgZm9yIHBhcnRpdGlvbmVkIHRhYmxlcy4pCgpBdXRob3I6IEFtdWwgU3VsIDxzdWxh bXVsQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEpvZWwgSmFjb2Jzb24gPGpvZWxAY29tcGlsZXIu b3JnPgpSZXZpZXdlZC1ieTogQW5kcmV3IER1bnN0YW4gPGFuZHJld0BkdW5zbGFuZS5uZXQ+ClJl dmlld2VkLWJ5OiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRyYXV0Lm9yZz4KUmV2aWV3 ZWQtYnk6IGppYW4gaGUgPGppYW4udW5pdmVyc2FsaXR5QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6 IEFsdmFybyBIZXJyZXJhIDxhbHZoZXJyZUBhbHZoLm5vLWlwLm9yZz4KUmV2aWV3ZWQtYnk6IEFz aHV0b3NoIEJhcGF0IDxhc2h1dG9zaC5iYXBhdC5vc3NAZ21haWwuY29tPgpSZXZpZXdlZC1ieTog SXNhYWMgTW9ybGFuZCA8aXNhYWMubW9ybGFuZEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBBbGV4 YW5kcmEgV2FuZyA8YWxleGFuZHJhLndhbmcub3NzQGdtYWlsLmNvbT4KVGVzdGVkLWJ5OiBUcml2 ZW5pIE4gPHRyaXZlbmkubkBlbnRlcnByaXNlZGIuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3d3 dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQvQ0FBSl9iOTYyYzVBY1lXOUtVdF9SX0VS NXFzM2ZVR2JlNGF6LVNQLXZ1d1BTLXctQUdBQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0t Cm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2Nv bW1pdGRpZmYvZWVjMDA0MGM0YmNkNjUwOTkzYmIwNThlYmRmNjFhYjk0MTcxZmRhNAoKTW9kaWZp ZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL2NhdGFsb2dzLnNnbWwgICAgICAg ICAgICAgICAgfCAgIDEgLQpkb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwgICAgICAg ICB8ICAgNSArLQpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICB8ICAg MiArLQpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX2NvbnN0cmFpbnQuYyAgICAgICB8ICAgNSArLQpz cmMvYmFja2VuZC9jYXRhbG9nL3NxbF9mZWF0dXJlcy50eHQgICAgICB8ICAgMiArLQpzcmMvYmFj a2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICB8IDQ3MyArKysrKysrKysrKysrKysr KysrKysrKystLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcGxhbmNhdC5jICAgICAg fCAgIDQgKwpzcmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55ICAgICAgICAgICAgICAgICB8ICAgOSAr LQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5jICAgICAgICB8ICAxNCArLQpzcmMv YmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5jICAgICAgICB8ICAgNiArLQpzcmMvYmluL3Bn X2R1bXAvcGdfZHVtcC5jICAgICAgICAgICAgICAgICB8ICAgOCArLQpzcmMvYmluL3BzcWwvZGVz Y3JpYmUuYyAgICAgICAgICAgICAgICAgICB8IDIxNiArKysrKysrLS0tLS0tLQpzcmMvaW5jbHVk ZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL3V0aWxz L3JlbC5oICAgICAgICAgICAgICAgICAgIHwgICAzICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9jb25zdHJhaW50cy5vdXQgfCAgIDggKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9mb3Jl aWduX2tleS5vdXQgfCAxOTQgKysrKysrKysrKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv aW5oZXJpdC5vdXQgICAgIHwgIDgxICsrLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2ZvcmVpZ25f a2V5LnNxbCAgICAgIHwgMTE5ICsrKysrKystCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2luaGVyaXQu c3FsICAgICAgICAgIHwgICA3ICsKMTkgZmlsZXMgY2hhbmdlZCwgODg1IGluc2VydGlvbnMoKyks IDI3NCBkZWxldGlvbnMoLSkKCg== --===============2803646975087003017==--