Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppv3u-0003Rr-Mn for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 18:00:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppv3t-0004eF-Kd for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 18:00:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppv3t-0004e4-BA for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 18:00:45 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ppv3o-004HXr-OU for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 18:00:44 +0000 Received: from [192.168.127.4] (port=10199 helo=erlenstar.riddles.org.uk) by lungold.riddles.org.uk with esmtp (Exim 4.92.3 (FreeBSD)) (envelope-from ) id 1ppv3k-000Cq6-4i; Fri, 21 Apr 2023 18:00:36 +0000 Received: from localhost ([127.0.0.1]:38054 helo=erlenstar.riddles.org.uk) by erlenstar.riddles.org.uk with esmtp (Exim 4.94 (FreeBSD)) (envelope-from ) id 1ppv3j-0007zR-Ly; Fri, 21 Apr 2023 18:00:36 +0000 From: Andrew Gierth To: Peter Eisentraut Cc: Sandro Santilli , Tom Lane , Regina Obe , pgsql-hackers@lists.postgresql.org, Jeff Davis Subject: Re: Order changes in PG16 since ICU introduction In-Reply-To: <533d93c5-f604-8e5f-4a48-975c08c53d59@enterprisedb.com> (Peter Eisentraut's message of "Fri, 21 Apr 2023 19:14:13 +0200") Message-ID: <878relf7cb.fsf@news-spur.riddles.org.uk> References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> <533d93c5-f604-8e5f-4a48-975c08c53d59@enterprisedb.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (berkeley-unix) Date: Fri, 21 Apr 2023 19:00:35 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >>>>> "Peter" == Peter Eisentraut writes: Peter> If the database is created with locale provider ICU, then Peter> lc_collate does not apply here, Having lc_collate return a value which is silently being ignored seems to me rather hugely confusing. Also, somewhere along the line someone broke initdb --no-locale, which should result in C locale being the default everywhere, but when I just tested it it picked 'en' for an ICU locale, which is not the right thing. -- Andrew (irc:RhodiumToad)