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 1ob169-0006QN-9l for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2022 14:53:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ob168-00029Q-5Y for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2022 14:53:12 +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 1ob167-00029G-Rg for pgsql-hackers@lists.postgresql.org; Wed, 21 Sep 2022 14:53:11 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ob160-0002xP-LY for pgsql-hackers@postgresql.org; Wed, 21 Sep 2022 14:53:10 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id CB2205C016D; Wed, 21 Sep 2022 10:53:03 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Wed, 21 Sep 2022 10:53:03 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1663771983; x= 1663858383; bh=Rs+Z/NXir4broi9HqyzzpTGZHd2BmMcuUde94RzkrII=; b=Y duIUIJZozqfhei936mniVtrnwV+jxpChYtcPCz6CIqACA404XX/w4d96LCn9FNxs iZJG8CUOYMIIPi1+iGT8+/FgFEhOzkCZiaHIKIAWmS4NBchYnN+Xv2KIqgJzRN10 oW4Y/lsZXN7CAtrJLwUDDT5PzLnKEzLpOuxtPzD7Jh9jJsL2i0cMzaLRsIgMFizq gyOru6RCiYbPoKnq4+UM+e3bMG9ZjeKDc9cTF4DEGGwm5A9GhCG3AW524koY18Si 0Tu5JiMldrKsaWHmEwFI7IK4JBWaBDYe0V8ljeD45YmEXxQJnL6V7b/f5s51EpDF wBcKYkGuKGi+JqKQGPi+A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrfeefuddgkedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvghnth gvrhhprhhishgvuggsrdgtohhmqeenucggtffrrghtthgvrhhnpefhjeduueelfeehuedt udefteejveegieeiueejueehfeektddtueeiieeitefhveenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvghnthhrrghu thesvghnthgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Feedback-ID: i131946ab:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 21 Sep 2022 10:53:00 -0400 (EDT) Message-ID: Date: Wed, 21 Sep 2022 10:53:00 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: ICU for global collation Content-Language: en-US To: Marina Polyakova Cc: Kyotaro Horiguchi , pgsql-hackers@postgresql.org, pryzby@telsasoft.com, rjuju123@gmail.com, daniel@manitou-mail.org, AndrewBille@gmail.com, michael@paquier.xyz References: <1f86f120-7b02-68f6-a434-132d054afe33@enterprisedb.com> <38d2aac40a991b20adf032e509c6eff5@postgrespro.ru> <6dd6db0984d86a51b7255ba79f111971@postgrespro.ru> <20220915.155210.529619933474389138.horikyota.ntt@gmail.com> <65ef1a8a-1fc3-3dc3-c7aa-6b9f649014b2@enterprisedb.com> <9ba4cd1ea6ed6b7b15c0ff15e6f540cd@postgrespro.ru> <218b963e-dd66-626a-abd8-962afb587876@enterprisedb.com> <36737f855bf3c44e701097cafd0ee2c9@postgrespro.ru> From: Peter Eisentraut In-Reply-To: <36737f855bf3c44e701097cafd0ee2c9@postgrespro.ru> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 21.09.22 08:50, Marina Polyakova wrote: > On 2022-09-20 12:59, Peter Eisentraut wrote: >> On 17.09.22 10:33, Marina Polyakova wrote: >>> 3. >>> >>> The locale provider is ICU, but it has not yet been set from the >>> template database: >>> >>>> $ initdb --locale-provider icu --icu-locale en-US -D data && >>>> pg_ctl -D data -l logfile start && >>>> createdb --icu-locale ru-RU --template template0 mydb >>>> ... >>>> createdb: error: database creation failed: ERROR:  ICU locale cannot be >>>> specified unless locale provider is ICU >> >> Please see attached patch for a fix.  Does that work for you? > > Yes, it works. The following test checks this fix: Committed with that test, thanks. I think that covers all the ICU issues you reported for PG15 for now?