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 1q6cC2-0003L7-Go for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Jun 2023 19:18:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q6cC1-0000mu-1j for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Jun 2023 19:18:09 +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 1q6cC0-0000mh-Nx for pgsql-hackers@lists.postgresql.org; Tue, 06 Jun 2023 19:18:08 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q6cBx-000dO0-GK for pgsql-hackers@lists.postgresql.org; Tue, 06 Jun 2023 19:18:07 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id 3f1490d57ef6-bacf5b89da7so7770854276.2 for ; Tue, 06 Jun 2023 12:18:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1686079084; x=1688671084; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=ho8CdcjWdLnEqqT61CCOyTJFKpuFrJapOEwqYVGXZmo=; b=o0IKYkZJre42xQqpFwxt26TE3XoBqpWtRhnUkaZwhobamUETssSwapyUaobO3eTQIj UUcgHYUxxmCLPqnTK0M/q5zs5v5+qHxofyovDw1ZzTU1lMvaPY0iMe9rxTUIsfEJD/Mu I4B8Td8KX2JGuleoTm/YfkXhbhmDj/v0+/0loe1D/Pm/SCcuzH6lUQNBQR4+mVisPwjG xhamGk8oIt0g3cpHFBuqGe1ezCpROMIGMCynbOZCKOvr7WHBahJeT+1t7zzX2nmSo/5o gYhYnVRTK4bzNYSLF9+Rr52tCWCJBRgHz9d4V1uIBM+ERh7i4g+JhEDUo8+kzc57h9Q5 /bAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686079084; x=1688671084; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ho8CdcjWdLnEqqT61CCOyTJFKpuFrJapOEwqYVGXZmo=; b=AF3r7ki2DoLHXavcSgf4DJ9/Lr+c24ZcWKd7Y80S8qWykp7ITwVfA3LJSGM3A+TP6D RMglLU+yWl3LfyKSqXCvjb7HMSpyCwDIWFxQuwk4JBs/qow5egqpl/LunTP1WP5/xPQ3 sc4TLfeIguCnXNa7C5nhLEn1Xc8tSLsBa8RwtPK85oFBaRYjXbopszs6SARmxVKRU055 AHTixaza2QY0lNRJE/HZUmGE65iuACBdGqNX+vGK74jtH6g6EBkwL1W8pqlERhUHDFd3 W/YtiOnhHHhyUCfBb3z0m/5+J9/7Ux+9iczyXHJYEFOHno673EFxCYSiYSkwZyh7GLCm 2Yow== X-Gm-Message-State: AC+VfDw35JxIfxh1QafCU7VlSc2j7NtLI9a21UrkuRm8E+r3V44i1V0F zSoAkYhxeEO0E8oAqUARPA9yWw== X-Google-Smtp-Source: ACHHUZ5jXUgjAvQnfWIMxXzGZtVBEBerY0JtCeSgies2NBT2liDMhrvSQS3RTiu0UQkEK2tdaI1yOA== X-Received: by 2002:a81:4e58:0:b0:568:fdc2:5af7 with SMTP id c85-20020a814e58000000b00568fdc25af7mr2918233ywb.50.1686079083876; Tue, 06 Jun 2023 12:18:03 -0700 (PDT) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id x15-20020a0dd50f000000b0055a486140b6sm4290831ywd.36.2023.06.06.12.18.03 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 06 Jun 2023 12:18:03 -0700 (PDT) Message-ID: <692bed6e-d86f-094b-11ab-9d4ccc2c802a@joeconway.com> Date: Tue, 6 Jun 2023 15:18:02 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Order changes in PG16 since ICU introduction Content-Language: en-US To: Jeff Davis , Daniel Verite Cc: Peter Eisentraut , Andrew Gierth , Tom Lane , pgsql-hackers@lists.postgresql.org References: <45f0cd77-9c85-4c5e-9396-adbccdb635e2@manitou-mail.org> <6b3df50c-3195-4f40-e04f-c25f489383f7@joeconway.com> From: Joe Conway In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/6/23 15:15, Jeff Davis wrote: > On Tue, 2023-06-06 at 14:11 -0400, Joe Conway wrote: >> This discussion makes me wonder (though probably too late for the v16 >> cycle) if we shouldn't treat "C" and "POSIX" locales to be a third >> provider, something like "internal". > > That's exactly what I did in v6 of this series: I created a "none" > provider, and when someone specified provider=icu iculocale=C, it would > change the provider to "none": > > https://www.postgresql.org/message-id/5f9bf4a0b040428c5db2dc1f23cc3ad96acb5672.camel%40j-davis.com > > I'm fine with either approach. Ha! Well it seems like I am +1 on that then ;-) -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com