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 1nV7ER-0008GT-Lp for pgsql-committers@arkaria.postgresql.org; Fri, 18 Mar 2022 07:41:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nV7EQ-0005uJ-Ap for pgsql-committers@arkaria.postgresql.org; Fri, 18 Mar 2022 07:41:06 +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 1nV7EQ-0005u9-3o for pgsql-committers@lists.postgresql.org; Fri, 18 Mar 2022 07:41:06 +0000 Received: from mail-pj1-x102c.google.com ([2607:f8b0:4864:20::102c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nV7EK-0001sL-HZ for pgsql-committers@lists.postgresql.org; Fri, 18 Mar 2022 07:41:05 +0000 Received: by mail-pj1-x102c.google.com with SMTP id v4so6849486pjh.2 for ; Fri, 18 Mar 2022 00:41:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=YPeGYfU6ZgeyXCz+iiVMbFneol1WmmwOTsUpgTtUL+U=; b=jNkmtraS+evjE/myrE8gUGwRJeYYefRpRg9wNs9RK38VhddjLza61OT311v/wGGyxP rmBHqneop2Ut9zLT2+8YtfwB0ajjbp4lxBwismZSi2phA/eKNpq2qiQQc73ZD/aQdodt /rMCzz+h+vzI2Z2mWzmwTOGiUU26BQN+J0U6TY1sgn5RPj5AbVL+rCkJ8k73r0iwhS8p UiGXdTNA3hiuVS7j1X2BdM5SEt1kIu/SfqVwNSFJX8RQPywn3ARFIug+npkw9h9SV2So U7McgkU3IZ2oiLhJjfph8Da6L1YD3W0j0nDL3R9zqxwtX1cvi0r6zSULRAUa0sT3GF91 acxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=YPeGYfU6ZgeyXCz+iiVMbFneol1WmmwOTsUpgTtUL+U=; b=SVQVY+hVg3V0U1tqdYXofP6/zFK3uidXQhDIVN9WsxWwYNfcyG6HhzkH5ikQPHdpKZ PcHFn4QEjzVqqQnptGqaXHwOO/Qoo/SPBasyTJr0fBCAYmNymxBPiDL1WNVOLvVimOy4 6rD5YaoAUkpAP1DZOE7vsD4nhAiotyiG9YLozorNILmjqJC93cPhiM0ijhGR1xBql0Fp CpDROa5EhC9m+D0nFAxrDPVaQZGx9VJOvK5PvF7rOEpXvUZLDCjpi0Dg5oFWCXALpQs6 MvEfz1QvpeRpwY6XbwD2xZ8uFi0uFbTeKooPPyrwrbhhiDYmEc46szJ70q0T49TE+LkD Zrtg== X-Gm-Message-State: AOAM531ekfRQRJLidTn0Y9II/8lr0FN0VTIn1WX3jxdPm2td04R5FSzI SP6gw/WACyOJEu8iNZlSXXk= X-Google-Smtp-Source: ABdhPJw2YhW4x2uwj4lUgWqvnxXOPahVEsdNMVC/Ls8ixp5E8AJ+pbag344GgOBWn9MgHwbCUGtOnw== X-Received: by 2002:a17:902:b202:b0:151:4f64:e516 with SMTP id t2-20020a170902b20200b001514f64e516mr9034363plr.16.1647589258753; Fri, 18 Mar 2022 00:40:58 -0700 (PDT) Received: from jrouhaud (2001-b011-1005-9591-25eb-5898-3273-93a3.dynamic-ip6.hinet.net. [2001:b011:1005:9591:25eb:5898:3273:93a3]) by smtp.gmail.com with ESMTPSA id z2-20020aa79902000000b004f75842c97csm9448882pff.209.2022.03.18.00.40.53 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Mar 2022 00:40:58 -0700 (PDT) Date: Fri, 18 Mar 2022 15:40:51 +0800 From: Julien Rouhaud To: Thomas Munro Cc: Michael Paquier , Peter Eisentraut , pgsql-committers Subject: Re: pgsql: Add option to use ICU as global locale provider Message-ID: <20220318074051.n46mkwp2zkbxeesf@jrouhaud> References: <20220318031244.tu3wwlyxxabzq3iu@jrouhaud> <20220318063648.4ja6rxlyzvc3viio@jrouhaud> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20220318063648.4ja6rxlyzvc3viio@jrouhaud> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 18, 2022 at 02:36:48PM +0800, Julien Rouhaud wrote: > On Fri, Mar 18, 2022 at 06:15:47PM +1300, Thomas Munro wrote: > > > > No idea what's happening here but one observation is that that animal > > is running an older distro that shipped with ICU 5.0. Commit b8f9a2a6 > > may hold a clue... > > Right. I'm setting up a similar podman environment, hopefully more info soon. And indeed b8f9a2a6 is the problem. We would need some form of icu_set_collation_attributes() on the frontend side if we want to detect such a problem on older ICU version at the expected moment rather than when bootstrapping the info. A similar check is also needed in createdb(). I was thinking that this could be the cause of problem reported by Andres on centos 7 (which seems to ship ICU 50), but postinit.c calls make_icu_collator(), which sets the attribute as expected. Maybe it's because old ICU version simply don't understand locale ID like "en-u-kf-upper" and silently falls back to the root collator?