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-009I5G-Ru 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-006fMb-Id 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 1u0r8m-006e0c-Ej for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 00:12:04 +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-003RtL-2w for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 00:12:04 +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-000HDJ-TT 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-002iU2-0a for pgsql-committers@lists.postgresql.org; Sat, 05 Apr 2025 00:11:59 +0000 Content-Type: multipart/mixed; boundary="===============2374702562797706428==" 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 --===============2374702562797706428== 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 UkVMXzE2X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3Jn L3BnL2NvbW1pdGRpZmYvZmIzYTc3ZmQ5ZGIwMzYxMGM1YWYyMTlkOWRkZmI0OTlkNzdkZjUwNQoK TW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9wZ19jb25z dHJhaW50LmMgICAgICAgfCAgMyArKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMg ICAgICAgICAgfCAzNSArKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvZm9yZWlnbl9rZXkub3V0IHwgIDMgKystCnNyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2ZvcmVpZ25fa2V5LnNxbCAgICAgIHwgIDMgKystCjQgZmlsZXMgY2hhbmdlZCwgMzQgaW5z ZXJ0aW9ucygrKSwgMTAgZGVsZXRpb25zKC0pCgo= --===============2374702562797706428==--