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 1ssPla-008GmB-SD for pgsql-general@arkaria.postgresql.org; Sun, 22 Sep 2024 16:48:59 +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 1ssPlY-008lQX-1B for pgsql-general@arkaria.postgresql.org; Sun, 22 Sep 2024 16:48:56 +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 1ssPlX-008lQP-MS for pgsql-general@lists.postgresql.org; Sun, 22 Sep 2024 16:48:55 +0000 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ssPlT-000XAP-Iy for pgsql-general@lists.postgresql.org; Sun, 22 Sep 2024 16:48:55 +0000 Received: by mail-wm1-x330.google.com with SMTP id 5b1f17b1804b1-42cbb08a1a5so33789015e9.3 for ; Sun, 22 Sep 2024 09:48:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727023732; x=1727628532; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=gKeH8lK34VTARqormXDeam3jKSHFr6Qx80/0ej6E21A=; b=IZIr42JSakOANRigXPHnB+Tzi4bzsfdiQijj30eX3uBJbSnagxhXlcJAGCCoNyP8mG ycjTCful6SHrrBoZzjgxdRjbDjdHjMBH1SeWI0wbV0vry63m2rrzGVCo8Y9R5/YklFev lScizemUOx0qL72Dc5XwESStlTR8N8FZvukJe7/9KaLMko/cJr1Cr/FrFtXdXxvnrVRL 6KtvnyWZvLKbc+dk7arJSaMMvRKRp3HiEPE9gX6X+4st/3nO3iW8SMO6FgQ2d9RDmfRL DX9ku3jrT8020F1deIvcIzRuVllWkkDhlBNGETDt0VfVg47CMAz5h0vq60WnORjdKMz1 9hrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727023732; x=1727628532; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=gKeH8lK34VTARqormXDeam3jKSHFr6Qx80/0ej6E21A=; b=c9yUvN2+nF3O4RjVRB8Hf8ku8SvtWaYhCjgm2d0W/WyTi98dOeCsTNTTxuL0e+XLwY NSgHJ1B64r1JNWxGCxCk8COiPIac9jOw7HF+0ZQMkRm+43j7eBuGCiUF8TFH2yJEcPZA HnAsDlHHtPHZvHf6Rh2904DR379gtw7O5MreJ4Hj0wXB0gOxFoNmGB86zj1tL03zrYSi xtsc7ES5dzpIUU7aDRUWKIA2JYPHB+nS69FsEzfhMmLQDlWYpPooplQFeCOqZZUOCUvc 9T4CAOlcyL3Wk7J9cdpW5sSImeok4O1Pyi/vngdBmBplPpWfSvr2qeeaFS1g/GoTjYGV jeNg== X-Forwarded-Encrypted: i=1; AJvYcCXzN4p8TOXzyhYzPJGvsIsrzb+ECFUJAUCwsgOIY9u/vv1zp0DDpJOq7iZTH51VRroOu37ReHYDR/Ijlvu4@lists.postgresql.org X-Gm-Message-State: AOJu0YxDlcm19D/pP//oxW5SkxDlQDmBdFApZbiIGm4U8ik7xmtbkPpg bUxkFsH61W+LHeINQPhRNmitP+VdS4nTooxkWYzg5CWOhQ5lUZ6c X-Google-Smtp-Source: AGHT+IHvm3HquSQHuDfuxSk+Ak0d9Af3rz8fGQqUtBcZo7Dgg6Q7MxsibWuyJLgM2xUoKjlftQ9eEg== X-Received: by 2002:a05:600c:458d:b0:42c:a8cb:6a75 with SMTP id 5b1f17b1804b1-42e7ac35e0fmr77682805e9.17.1727023730968; Sun, 22 Sep 2024 09:48:50 -0700 (PDT) Received: from smtpclient.apple (26-36-239-77.dyn.cable.qlnet.ch. [77.239.36.26]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-42e754c6148sm105834145e9.44.2024.09.22.09.48.50 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 22 Sep 2024 09:48:50 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.10\)) Subject: Re: glibc updarte 2.31 to 2.38 From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: Date: Sun, 22 Sep 2024 18:48:46 +0200 Cc: "Peter J. Holzer" , pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <2D395465-69B2-46C9-9B6A-84BF73D2379A@gmail.com> References: <20240919174349.grrz4w25jmxfk77a@hjp.at> <58CD40AA-6316-40B6-89C2-390D16FF5FA0@gmail.com> <20240920223316.muvdgqekzh6dvcii@hjp.at> To: Joe Conway X-Mailer: Apple Mail (2.3696.120.41.1.10) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Joe > On 22. Sep, 2024, at 15:47, Joe Conway wrote: >=20 > Note that moving to ICU might improve things, but there are similar = potential issues with ICU as well. The trick there would be to get your = OS distro provider to maintain the same ICU version across major = versions of the distro, which is not the case currently. Nor does the = PGDG repo do that. Then I strongly suggest that the PostgreSQL developers develop a fail = safe sorting mechanism that holds for generations of locale changes. Cheers, Paul