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 1q73tY-0002RY-CU for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 00:52:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q73tW-0006hp-70 for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 00:52:54 +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 1q73tV-0006hg-Gc for pgsql-hackers@lists.postgresql.org; Thu, 08 Jun 2023 00:52:53 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q73tR-000vV5-Vc for pgsql-hackers@lists.postgresql.org; Thu, 08 Jun 2023 00:52:52 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-568ba7abc11so240787b3.3 for ; Wed, 07 Jun 2023 17:52:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1686185567; x=1688777567; 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=0fBvjIS5riM5BwFrZWQ7YbEos53To5hEkF9L4M2i5DU=; b=Ye/1UDCB0kVWh5oP1Njn+4D7alPAwRwUY5ix/qfFJDYgTfo4EMUDxJVw5Jhn89g9Hy amTiWQh5enRW++qlOfCbQjXXvz+1Go1Q72VQ+itZzNv7P3B/zKK9gTHTnbZGLgpAfxBd xD1OyPPAX/iRdLP6lKbw/a5dFheFs089+aI6DYppsU8do+fBHaq1PqrzRmiQC0m2fT4+ M6W7tDhxipmylQMHcnDxmVYhsFVxPSmTpO7R1YezdQe5Lg9jYKESgCuEDInSxQpFWTaH aM3hGDaSyQfzAQ1QLSO1yuIdKxo0nbTOl91AuLPvqY9crZ5xWbBweeAId4tvXybQBgts BWig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686185567; x=1688777567; 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=0fBvjIS5riM5BwFrZWQ7YbEos53To5hEkF9L4M2i5DU=; b=SweIVlxxvJ+i+gwjOfHMFskcRato6rNkyd4kTMWJ/RfkMO8q5f4iXJr+Za7LsfWJ61 FiQLs/vofsuu870ayIYJcCctWHGJb4DdlkSO8IZ5EJSUq/A04XkGX0lz+eh3WmigUc9b mu3dTpM9S2CP+BztTa7VkiZDhWRaa3whvEdWUcHjjbVE0G/Zl60KfXZ8+DDCwoOqF6+m PUTlaCVy2UXc95mWS1sKApqyFJQxufF1ECsWBrWSkFsOJMLS2vu6QExRLEogCKgKeWSr 82BAb35+rLFVngkvL/qAuK5aqcmkuQCsGreS2mDWh/PA/+3K3ghgdJq+Q+QxbR/r7osU GmRw== X-Gm-Message-State: AC+VfDxK8oG7kw+MxKaEWakhZGymIgi1tqfUych6EGeVopDJJ002Y8Dp v8n/urZeR6FGkDf7VbacLQqZNw== X-Google-Smtp-Source: ACHHUZ4iQQm99V2gERYhhmsWCmH9kmxhzj35BlsrMY3Laap9zIrmPTP/yW2sHZm3/26ZtcZ1jFjFaw== X-Received: by 2002:a81:a006:0:b0:559:f861:9e0b with SMTP id x6-20020a81a006000000b00559f8619e0bmr8753534ywg.5.1686185567708; Wed, 07 Jun 2023 17:52:47 -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 a8-20020a816608000000b00569fc679091sm46087ywc.103.2023.06.07.17.52.47 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 07 Jun 2023 17:52:47 -0700 (PDT) Message-ID: <5ecb1eec-c115-6de9-8dd4-4bf214b8ebda@joeconway.com> Date: Wed, 7 Jun 2023 20:52:46 -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 , 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> 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/7/23 19:26, Jeff Davis wrote: > * What do we do in the case where the environment has LANG=C.UTF-8 (as > some buildfarm members do)? Is an error acceptable in that case? If I understand the discussion so far correctly, I think that case should fall to the provider. If it supports "C.UTF-8" explicitly as some distributions do, then use it. If the provider has no such thing, throw an error. Somewhere we should document that "C.UTF-8" from the provider might not be as stable or working as they expect. -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com