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 1q7Nfe-0001BB-6w for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 21:59:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q7Nfb-00025J-Ps for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 21:59:51 +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 1q7Nfb-000259-3O for pgsql-hackers@lists.postgresql.org; Thu, 08 Jun 2023 21:59:51 +0000 Received: from mail-yw1-x112e.google.com ([2607:f8b0:4864:20::112e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q7NfX-00161U-Q6 for pgsql-hackers@lists.postgresql.org; Thu, 08 Jun 2023 21:59:50 +0000 Received: by mail-yw1-x112e.google.com with SMTP id 00721157ae682-565e6beb7aaso10331987b3.2 for ; Thu, 08 Jun 2023 14:59:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1686261585; x=1688853585; h=content-transfer-encoding:in-reply-to:subject:from:references:cc:to :content-language:user-agent:mime-version:date:message-id:from:to:cc :subject:date:message-id:reply-to; bh=2cMaBvq2BKaw1niiI4ISGyuXqjUuj1SG00lKPpoFBhs=; b=nompP0T5imaEHoAnNuq2l/OLuTEwo6GciJv3syyFIWhB0yQCFagBNWUUkH9Gq4n6wl 78Vfnt3TS1BHKKA/KC6b8GKBHFwN6AfJLOJDb+oaaq8EIPadM59/gqaodKSAb9V/+Qvn H/P2xm0xdioT9RyKhEGQRJkEUoiIuTdrzg+p+mATawHFteLdXHuT8z4eyodtw8xfia+o FMp08RKgUlYDNbUw2CGa7kcSDVgrTJ6hPqa3QKo841ZqdhnB7+GToruqeKMYNZJV6+XO v4uRTq3sXlQgiEEqKHm5lbqtZkZwlEHnbC6TP5L/hDwSbKMPIFPDXZtnir+lsjphMrb4 6u5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686261585; x=1688853585; h=content-transfer-encoding:in-reply-to:subject:from:references:cc:to :content-language:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=2cMaBvq2BKaw1niiI4ISGyuXqjUuj1SG00lKPpoFBhs=; b=he9n3Qd6dBaFqYeywvQa+6mUJdv0tccLkzkWXgr1upJyIFIn8EhDoMC9MDWsbp0fNQ 0eTH+e7/oTppYnEnReQHPQg4b+dRdHbxk8tyxH2agsKmLuBkCeBghW3Lpci0vWZOawFk 15BFfYry0OgE3We/amk/otVgpPMvRIo0yojoZenSGNcjyvjqtZ4CeL1c6iOGJT/WJImE r6Aj9O4QPYuaWQAfNf+CZrMx8n4NPxn+1YW2pRUKGXj6z+u2ZMSHJ2bxeZbpzk20RmPE p00mbGfmylD0msLTtkcnU1tOMm0F3TYq78sq/lkbBVkpWw6Qm5wwLEe8BoHAPl2G8Liz Jm4w== X-Gm-Message-State: AC+VfDwbbEm9IS4cWGWGBxoMGl+HxOIS2O5snBwSWo4zkeja9U83jK58 94qfiMTjG2anI2IFbvdTG1Theg== X-Google-Smtp-Source: ACHHUZ7IVgi3n8/uzEuJQ5xcFCymG/1Nc0rc/91Lwz6U/+rTaF4chHn+bDUkESty8aT/j27vQWaKag== X-Received: by 2002:a0d:d453:0:b0:56c:b6ef:c91e with SMTP id w80-20020a0dd453000000b0056cb6efc91emr908137ywd.26.1686261584823; Thu, 08 Jun 2023 14:59:44 -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 i143-20020a819195000000b00565e57e6662sm197896ywg.55.2023.06.08.14.59.44 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 08 Jun 2023 14:59:44 -0700 (PDT) Message-ID: <097aac39-fe4f-1d3c-e3a2-5563ffc0aa3d@joeconway.com> Date: Thu, 8 Jun 2023 17:59:43 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Content-Language: en-US To: Jeff Davis , Peter Eisentraut , Daniel Verite Cc: Andrew Gierth , Tom Lane , pgsql-hackers@lists.postgresql.org References: <543e4ce6-8205-4aea-b54b-12b9ef747bf6@manitou-mail.org> <654a49f7ff7461bcf47be4181430678d45f93858.camel@j-davis.com> <37520ec1ae9591f83132f82dbd625f3fc2d69c16.camel@j-davis.com> <5111ffef640ec7ed5b75d9791dd18d821e96c31e.camel@j-davis.com> <0f03fa26-741c-b1ee-12ab-566116451ab1@eisentraut.org> <5ecb1eec-c115-6de9-8dd4-4bf214b8ebda@joeconway.com> <20f4e529e17af61bce11fe05cb056f28a809b840.camel@j-davis.com> From: Joe Conway Subject: Re: Order changes in PG16 since ICU introduction In-Reply-To: <20f4e529e17af61bce11fe05cb056f28a809b840.camel@j-davis.com> 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/8/23 17:15, Jeff Davis wrote: > On Wed, 2023-06-07 at 20:52 -0400, Joe Conway wrote: >> If the provider has no such thing, throw an error. > > Just to be clear, that implies that users (and buildfarm members) with > LANG=C.UTF-8 in their environment would not be able to run a plain > "initdb -D data"; they'd get an error. It's hard for me to estimate how > many users might be inconvenienced by that, but it sounds like a risk. Well, but only if their libc provider does not have C.UTF-8, correct? I see ---------------- Linux Mint 21.1: /usr/lib/locale/C.utf8 RHEL 8: /usr/lib/locale/C.utf8 RHEL 9: /usr/lib/locale/C.utf8 AL2: /usr/lib/locale/C.utf8 However I do not see it on RHEL 7 :-( > Perhaps for this specific case, and only in initdb, we change > C.anything and POSIX.anything to the builtin provider? Might be best, with some kind of warning perhaps? > CREATE DATABASE and CREATE COLLATION could still reject such > locales. Seems to make sense. -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com