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 1u0r9y-009I5F-S0 for pgsql-committers@arkaria.postgresql.org; Sat, 05 Apr 2025 00:13:18 +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 1u0r8z-006fMc-Ic for pgsql-committers@arkaria.postgresql.org; Sat, 05 Apr 2025 00:12:17 +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 1u0r8o-006eEj-8c for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 00:12:06 +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 1u0r8j-003RtK-33 for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 00:12:05 +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 1u0r8h-000HDG-TV for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 00:11:59 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u0r8h-002iTy-0O for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 00:11:59 +0000 Content-Type: multipart/mixed; boundary="===============4247891398307439297==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Repair misbehavior with duplicate entries in FK SET column lists X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 05 Apr 2025 00:11:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4247891398307439297== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVwYWlyIG1pc2JlaGF2aW9yIHdpdGggZHVwbGljYXRlIGVudHJpZXMgaW4gRksgU0VUIGNvbHVt biBsaXN0cy4KClNpbmNlIHYxNSB3ZSd2ZSBoYWQgYW4gb3B0aW9uIHRvIGFwcGx5IGEgZm9yZWln biBrZXkgY29uc3RyYWludCdzCk9OIERFTEVURSBTRVQgREVGQVVMVCBvciBTRVQgTlVMTCBhY3Rp b24gdG8ganVzdCBzb21lIG9mIHRoZQpyZWZlcmVuY2luZyBjb2x1bW5zLiAgVGhlcmUgd2FzIG5v dCBhIGNoZWNrIGZvciBkdXBsaWNhdGUgZW50cmllcyBpbgp0aGUgbGlzdCBvZiBjb2x1bW5zLXRv LXNldCwgdGhvdWdoLiAgVGhhdCBjYXVzZWQgYSBwb3RlbnRpYWwgbWVtb3J5CnN0b21wIGluIENy ZWF0ZUNvbnN0cmFpbnRFbnRyeSgpLCB3aGljaCBpbmNhdXRpb3VzbHkgYXNzdW1lZCB0aGF0CnRo ZSBsaXN0IG9mIGNvbHVtbnMtdG8tc2V0IGNvdWxkbid0IGJlIGxvbmdlciB0aGFuIHRoZSBudW1i ZXIgb2Yga2V5CmNvbHVtbnMuICBFdmVuIGFmdGVyIGZpeGluZyB0aGF0LCB0aGUgY2FzZSBkb2Vz bid0IHdvcmsgYmVjYXVzZSB5b3UKZ2V0IGFuIGVycm9yIGxpa2UgIm11bHRpcGxlIGFzc2lnbm1l bnRzIHRvIHNhbWUgY29sdW1uIiBmcm9tIHRoZSBTUUwKY29tbWFuZCB0aGF0IGlzIGdlbmVyYXRl ZCB0byBkbyB0aGUgdXBkYXRlLgoKV2UgY291bGQgZWl0aGVyIHJhaXNlIGFuIGVycm9yIGZvciBk dXBsaWNhdGUgY29sdW1ucyBvciBzaWxlbnRseQpzdXBwcmVzcyB0aGUgZHVwcywgYW5kIGFmdGVy IGEgYml0IG9mIHRob3VnaHQgSSBjaG9zZSB0byBkbyB0aGUKbGF0dGVyLiAgVGhpcyBpcyBtb3Rp dmF0ZWQgYnkgdGhlIGZhY3QgdGhhdCBkdXBsaWNhdGVzIGluIHRoZSBGSwpjb2x1bW4gbGlzdCBh cmUgbGVnYWwsIHNvIGl0J3Mgbm90IHJlYWwgY2xlYXIgd2h5IGR1cGxpY2F0ZXMKaW4gdGhlIGNv bHVtbnMtdG8tc2V0IGxpc3Qgc2hvdWxkbid0IGJlLiAgT2YgY291cnNlIHRoZXJlJ3Mgbm8KbmVl ZCB0byBhY3R1YWxseSBzZXQgdGhlIGNvbHVtbiBtb3JlIHRoYW4gb25jZS4KCkkgbGVmdCBpbiB0 aGUgZml4IGluIENyZWF0ZUNvbnN0cmFpbnRFbnRyeSgpIHRvbywganVzdCBiZWNhdXNlCml0IGRp ZG4ndCBzZWVtIGxpa2Ugc3VjaCBsb3ctbGV2ZWwgY29kZSBvdWdodCB0byBiZSBtYWtpbmcKYXNz dW1wdGlvbnMgYWJvdXQgd2hhdCBpdCdzIGhhbmRlZC4KCkJ1ZzogIzE4ODc5ClJlcG9ydGVkLWJ5 OiBZdSBMaWFuZyA8bHV5NzBAcHN1LmVkdT4KQXV0aG9yOiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gu cGEudXM+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTg4NzktMjU5ZmM1OWQwNzJi ZDRkN0Bwb3N0Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTUKCkJyYW5jaAotLS0tLS0K bWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29t bWl0ZGlmZi80M2I4ZTZjNGFiZmI2MzJiYmZmNWIzYTI2ZGMzOWJmM2YxODhhZmZmCgpNb2RpZmll ZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX2NvbnN0cmFpbnQu YyAgICAgICB8ICAzICsrLQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAg ICB8IDM1ICsrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9mb3JlaWduX2tleS5vdXQgfCAgMyArKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZm9y ZWlnbl9rZXkuc3FsICAgICAgfCAgMyArKy0KNCBmaWxlcyBjaGFuZ2VkLCAzNCBpbnNlcnRpb25z KCspLCAxMCBkZWxldGlvbnMoLSkKCg== --===============4247891398307439297==--