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 1oZTPB-0003E3-A0 for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Sep 2022 08:42:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oZTPA-0007b5-6M for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Sep 2022 08:42:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oZTP9-0007au-Tt for pgsql-hackers@lists.postgresql.org; Sat, 17 Sep 2022 08:42:27 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oZTP7-0005Nn-GZ for pgsql-hackers@postgresql.org; Sat, 17 Sep 2022 08:42:26 +0000 Received: from mail.postgrespro.ru (cyclops.postgrespro.ru [93.174.131.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 3BAFB21C04FB; Sat, 17 Sep 2022 11:42:24 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1663404144; bh=/3IviPbAfVcVswOTX5iRo+JkfvaCJHsCCfpdooyVQ2w=; h=Date:From:To:Cc:Subject:In-Reply-To:References; b=SX63PfGT23A/eOYAQjMTo73e3oQd4/ymXbcmUUmbeZNI9qsmXTWH/DiZzlHmtl2OP gy1JMFC/62qPOy7fi1xpjEty9K3vLGWukv5b6zbtK4qMR6PR+KolVwQYv84hydIMc7 j7Otka9rfg3QK4sdOstzq7an3NHXt+axEzFTHdgs= MIME-Version: 1.0 Date: Sat, 17 Sep 2022 11:42:24 +0300 From: Marina Polyakova To: Peter Eisentraut Cc: Kyotaro Horiguchi , pgsql-hackers@postgresql.org, pryzby@telsasoft.com, rjuju123@gmail.com, daniel@manitou-mail.org, AndrewBille@gmail.com, michael@paquier.xyz Subject: Re: ICU for global collation In-Reply-To: <26461c69-cbce-c286-1716-41148b5e0f06@enterprisedb.com> References: <1f86f120-7b02-68f6-a434-132d054afe33@enterprisedb.com> <38d2aac40a991b20adf032e509c6eff5@postgrespro.ru> <6dd6db0984d86a51b7255ba79f111971@postgrespro.ru> <20220915.155210.529619933474389138.horikyota.ntt@gmail.com> <2322791a368e9ad066edd648790b5e91@postgrespro.ru> <26461c69-cbce-c286-1716-41148b5e0f06@enterprisedb.com> User-Agent: Roundcube Webmail/1.4.11 Message-ID: <355a424f234f849c2515b9c4076feff0@postgrespro.ru> X-Sender: m.polyakova@postgrespro.ru Organization: Postgres Professional Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2022-09-16 10:56, Peter Eisentraut wrote: > On 15.09.22 17:41, Marina Polyakova wrote: >> I agree with you. Here's another version of the patch. The >> locale/encoding checks and reports in initdb have been reordered, >> because now the encoding is set first and only then the ICU locale is >> checked. > > I committed something based on the first version of your patch. This > reordering of the messages here was a little too much surgery for me > at this point. For instance, there are also messages in #ifdef WIN32 > code that would need to be reordered as well. I kept the overall > structure of the code the same and just inserted the additional > proposed checks. > > If you want to pursue the reordering of the checks and messages > overall, a patch for the master branch could be considered. Thank you! I already wrote about the order of the ICU checks in initdb/create database, they were the only reason to propose such changes... -- Marina Polyakova Postgres Professional: http://www.postgrespro.com The Russian Postgres Company