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 1tBwsw-007BvA-OW for pgsql-committers@arkaria.postgresql.org; Fri, 15 Nov 2024 14:01: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 1tBwsu-00A36Q-44 for pgsql-committers@arkaria.postgresql.org; Fri, 15 Nov 2024 14:01:16 +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 1tBwst-00A36I-Ry for pgsql-committers@lists.postgresql.org; Fri, 15 Nov 2024 14:01:16 +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.94.2) (envelope-from ) id 1tBwsp-00251l-Sv for pgsql-committers@lists.postgresql.org; Fri, 15 Nov 2024 14:01:15 +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 1tBwso-006Lqh-6B for pgsql-committers@lists.postgresql.org; Fri, 15 Nov 2024 14:01:11 +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 1tBwso-001wX1-3B for pgsql-committers@lists.postgresql.org; Fri, 15 Nov 2024 14:01:10 +0000 Content-Type: multipart/mixed; boundary="===============5195582942126300711==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix collation handling for foreign keys X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 15 Nov 2024 14:01:10 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5195582942126300711== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGNvbGxhdGlvbiBoYW5kbGluZyBmb3IgZm9yZWlnbiBrZXlzCgpBbGxvd2luZyBmb3JlaWdu IGtleXMgd2hlcmUgdGhlIHJlZmVyZW5jZWQgYW5kIHRoZSByZWZlcmVuY2luZyBjb2x1bW5zCmhh dmUgY29sbGF0aW9ucyB3aXRoIGRpZmZlcmVudCBub3Rpb25zIG9mIGVxdWFsaXR5IGlzIHByb2Js ZW1hdGljLgpUaGlzIGNhbiBvbmx5IGhhcHBlbiB3aGVuIHVzaW5nIG5vbmRldGVybWluaXN0aWMg Y29sbGF0aW9ucywgZm9yCmV4YW1wbGUsIGlmIHRoZSByZWZlcmVuY2luZyBjb2x1bW4gaXMgY2Fz ZS1pbnNlbnNpdGl2ZSBhbmQgdGhlCnJlZmVyZW5jZWQgY29sdW1uIGlzIG5vdCwgb3IgdmljZSB2 ZXJzYS4gIEl0IGRvZXMgbm90IGhhcHBlbiBpZiBib3RoCmNvbGxhdGlvbnMgYXJlIGRldGVybWlu aXN0aWMuCgpUbyBzaG93IG9uZSBleGFtcGxlOgoKICAgIENSRUFURSBDT0xMQVRJT04gY2FzZV9p bnNlbnNpdGl2ZSAocHJvdmlkZXIgPSBpY3UsIGRldGVybWluaXN0aWMgPSBmYWxzZSwgbG9jYWxl ID0gJ3VuZC11LWtzLWxldmVsMicpOwoKICAgIENSRUFURSBUQUJMRSBwa3RhYmxlICh4IHRleHQg Q09MTEFURSAiQyIgUFJJTUFSWSBLRVkpOwogICAgQ1JFQVRFIFRBQkxFIGZrdGFibGUgKHggdGV4 dCBDT0xMQVRFIGNhc2VfaW5zZW5zaXRpdmUgUkVGRVJFTkNFUyBwa3RhYmxlIE9OIFVQREFURSBD QVNDQURFIE9OIERFTEVURSBDQVNDQURFKTsKICAgIElOU0VSVCBJTlRPIHBrdGFibGUgVkFMVUVT ICgnQScpLCAoJ2EnKTsKICAgIElOU0VSVCBJTlRPIGZrdGFibGUgVkFMVUVTICgnQScpOwoKICAg IEJFR0lOOyBERUxFVEUgRlJPTSBwa3RhYmxlIFdIRVJFIHggPSAnYSc7IFRBQkxFIGZrdGFibGU7 IFJPTExCQUNLOwogICAgQkVHSU47IERFTEVURSBGUk9NIHBrdGFibGUgV0hFUkUgeCA9ICdBJzsg VEFCTEUgZmt0YWJsZTsgUk9MTEJBQ0s7CgpCb3RoIG9mIHRoZXNlIERFTEVURSBzdGF0ZW1lbnRz IGRlbGV0ZSB0aGUgb25lIHJvdyBmcm9tIGZrdGFibGUuICBTbwp0aGlzIG1lYW5zIHRoYXQgb25l IHJvdyBmcm9tIGZrdGFibGUgcmVmZXJlbmNlcyB0d28gcm93cyBpbiBwa3RhYmxlLAp3aGljaCBz aG91bGQgbm90IGhhcHBlbi4gIChUaGF0J3Mgd2h5IGEgcHJpbWFyeSBrZXkgb3IgdW5pcXVlCmNv bnN0cmFpbnQgaXMgcmVxdWlyZWQgb24gcGt0YWJsZS4pCgpXaGVuIG5vbmRldGVybWluaXN0aWMg Y29sbGF0aW9ucyB3ZXJlIGltcGxlbWVudGVkLCB0aGUgU1FMIHN0YW5kYXJkCmF2YWlsYWJsZSB0 byB5b3VycyB0cnVseSBzYWlkIHRoYXQgcmVmZXJlbnRpYWwgaW50ZWdyaXR5IGNoZWNrcyBzaG91 bGQKYmUgcGVyZm9ybWVkIHdpdGggdGhlIGNvbGxhdGlvbiBvZiB0aGUgcmVmZXJlbmNlZCBjb2x1 bW4sIGFuZCBzbwp0aGF0J3MgaG93IHdlIGltcGxlbWVudGVkIGl0LiAgQnV0IHRoaXMgdHVybmVk IG91dCB0byBiZSBhIG1pc3Rha2UgaW4KdGhlIFNRTCBzdGFuZGFyZCwgZm9yIHRoZSBzYW1lIHJl YXNvbnMgYXMgYWJvdmUsIHRoYXQgd2FzIGxhdGVyCihTUUw6MjAxNikgZml4ZWQgdG8gcmVxdWly ZSBib3RoIGNvbGxhdGlvbnMgdG8gYmUgdGhlIHNhbWUuICBTbyB0aGF0J3MKd2hhdCB3ZSBhcmUg YWltaW5nIGZvciBoZXJlLgoKV2UgZG9uJ3QgaGF2ZSB0byBiZSBxdWl0ZSBzbyBzdHJpY3QuICBX ZSBjYW4gYWxsb3cgZGlmZmVyZW50CmNvbGxhdGlvbnMgaWYgdGhleSBhcmUgYm90aCBkZXRlcm1p bmlzdGljLiAgVGhpcyBpcyBhbHNvIGdvb2QgZm9yCmJhY2t3YXJkIGNvbXBhdGliaWxpdHkuCgpT byB0aGUgbmV3IHJ1bGUgaXMgdGhhdCB0aGUgY29sbGF0aW9ucyBlaXRoZXIgaGF2ZSB0byBiZSB0 aGUgc2FtZSBvcgpib3RoIGRldGVybWluaXN0aWMuICBPciBpbiBvdGhlciB3b3JkcywgaWYgb25l IG9mIHRoZW0gaXMKbm9uZGV0ZXJtaW5pc3RpYywgdGhlbiBib3RoIGhhdmUgdG8gYmUgdGhlIHNh bWUuCgpVc2VycyB1cGdyYWRpbmcgZnJvbSBiZWZvcmUgdGhhdCBoYXZlIGFmZmVjdGVkIHNldHVw cyB3aWxsIG5lZWQgdG8KbWFrZSBjaGFuZ2VzIHRvIHRoZWlyIHNjaGVtYXMgKGkuZS4sIGNoYW5n ZSBvbmUgb3IgYm90aCBjb2xsYXRpb25zIGluCmFmZmVjdGVkIGZvcmVpZ24ta2V5IHJlbGF0aW9u c2hpcHMpIGJlZm9yZSB0aGUgdXBncmFkZSB3aWxsIHN1Y2NlZWQuCgpTb21lIG9mIHRoZSBuaWNl IHRlc3QgY2FzZXMgZm9yIHRoZSBwcmV2aW91cyBzaXR1YXRpb24gaW4KY29sbGF0ZS5pY3UudXRm OC5zcWwgYXJlIG5vdyBvYnNvbGV0ZS4gIFRoZXkgYXJlIGNoYW5nZWQgdG8ganVzdCBjaGVjawp0 aGUgZXJyb3IgY2hlY2tpbmcgb2YgdGhlIG5ldyBydWxlLiAgTm90ZSB0aGF0IGNvbGxhdGUuc3Fs IGFscmVhZHkKY29udGFpbmVkIGEgdGVzdCBmb3IgZm9yZWlnbiBrZXlzIHdpdGggZGlmZmVyZW50 IGRldGVybWluaXN0aWMKY29sbGF0aW9ucy4KCkEgYnVuY2ggb2YgY29kZSBpbiByaV90cmlnZ2Vy cy5jIHRoYXQgYWRkZWQgYSBDT0xMQVRFIGNsYXVzZSB0bwplbmZvcmNlIHRoZSByZWZlcmVuY2Vk IGNvbHVtbidzIGNvbGxhdGlvbiBjYW4gYmUgcmVtb3ZlZCwgYmVjYXVzZSBib3RoCmNvbHVtbnMg bm93IGhhdmUgdG8gaGF2ZSB0aGUgc2FtZSBub3Rpb24gb2YgZXF1YWxpdHksIHNvIGl0IGRvZXNu J3QKbWF0dGVyIHdoaWNoIG9uZSB0byB1c2UuCgpSZXBvcnRlZC1ieTogUGF1bCBKdW5nd2lydGgg PHBqQGlsbHVtaW5hdGVkY29tcHV0aW5nLmNvbT4KUmV2aWV3ZWQtYnk6IEppYW4gSGUgPGppYW4u dW5pdmVyc2FsaXR5QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvbWVzc2FnZS1pZC9mbGF0Lzc4ZDgyNGUwLWIyMWUtNDgwZC1hMjUyLWU0Yjg0YmMyYzI0 YkBpbGx1bWluYXRlZGNvbXB1dGluZy5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxz Ci0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85MzIxZDJm ZGY4MDhlOTMwOTVjNGY4NjU2NWRjOGM4MTc4Njc1ODQxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0t LS0tLS0tLQpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICAgICAgIHwg ICA3ICsrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgICAgICAgfCAg ODQgKysrKysrKysrKysrKysrKystLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9yaV90cmlnZ2Vy cy5jICAgICAgICAgICAgfCAgNTcgKysrKystLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9jb2xsYXRlLmljdS51dGY4Lm91dCB8IDEwMCArKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t CnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NvbGxhdGUuaWN1LnV0Zjguc3FsICAgICAgfCAgMzUgKy0t LS0tLS0tCjUgZmlsZXMgY2hhbmdlZCwgMTA1IGluc2VydGlvbnMoKyksIDE3OCBkZWxldGlvbnMo LSkKCg== --===============5195582942126300711==--