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 1q19RW-0004Rm-AN for pgsql-hackers@arkaria.postgresql.org; Mon, 22 May 2023 17:35:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q19RV-0001BP-3R for pgsql-hackers@arkaria.postgresql.org; Mon, 22 May 2023 17:35:33 +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 1q19RU-0001BG-HI for pgsql-hackers@lists.postgresql.org; Mon, 22 May 2023 17:35:32 +0000 Received: from mail-pf1-x42a.google.com ([2607:f8b0:4864:20::42a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q19RP-001FOx-6M for pgsql-hackers@lists.postgresql.org; Mon, 22 May 2023 17:35:31 +0000 Received: by mail-pf1-x42a.google.com with SMTP id d2e1a72fcca58-64d577071a6so2356596b3a.1 for ; Mon, 22 May 2023 10:35:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1684776926; x=1687368926; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=MEw7spPkDGhZ0v4mBK/yLyipIKSvZsz2oEFiRfml3K4=; b=siKxPPLxznmTDR+G7CwIlvvYSKUwB/TLt6cyoKhZN4F7YdIR1SrikD/RulSRsoicd8 imGQMkXJe708N9JzltlFQsdm4r1XizhnpQsnlxWf8NtHcA+EL6DxftuUCCtoWGpMs2KX 7mUizX383kggOMu9c+KcSsSR0+UxXd/Fvk/ZrA1Az9whWjSHVm9gULlGCsf8zAq4paUD dqWEukPKbwf8D6ilSqWGWeT82EbFK5O/doOog1+qEqtZFXVWqSSY+los6S33IwNP0TlE ogLKHRw9uMk3knVleb2zeM7YGVXPzm/1lVesiUi5mdMC6VvDk4lG3ZpSwDO8V05AB4Jo A2hw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684776926; x=1687368926; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=MEw7spPkDGhZ0v4mBK/yLyipIKSvZsz2oEFiRfml3K4=; b=LmcHEXMVE7rwhXdNRf5kWJFZiOjBVVRV4PkOsuDvVVLvK+DA7JR2WhOWB4rqezWniR Zx7yQyHyThm+PKhGrQVXBs6jBQJ3q+HIB88cZh264Kioxk+yJDBq/SV4gjQ6FL8cD/WZ HwxmKGn4LIF1s1eiVhRf4Z92yUS+yDdfLKoR+Q8oxjVhF2SRmoRR7Z1o/Av0LcI1LGrr vBeV8KLU/76tGuA/T1WqXCXDtiPShh+q/fbrngf2pgYHbP6p0kZhwaxrs4XQEtAG0Qez o8VDxaaglR3bxDPd76g8YY3HYbBYBoWftAGEEuNY6ocM4GKf1PDlqdb9crsGsuNsHDqc lM8g== X-Gm-Message-State: AC+VfDxKXwjSxj/hmLW9f0e9J9Bop65anIk6mu21SP3OmRXpjDTFtHpa MKiBD1xZy8sPAu2D883WIzlWdQ== X-Google-Smtp-Source: ACHHUZ5TUnMHVsBRhUtTm+GQprS/I4Sh6XrdMuZTOKVYYMazYLreVNJ7Iva5k91TDy/BXFUf1ltY1Q== X-Received: by 2002:a05:6a00:13a2:b0:64a:f9c7:1365 with SMTP id t34-20020a056a0013a200b0064af9c71365mr13604798pfg.30.1684776926339; Mon, 22 May 2023 10:35:26 -0700 (PDT) Received: from jeff-laptop.lan (c-73-170-46-202.hsd1.ca.comcast.net. [73.170.46.202]) by smtp.gmail.com with ESMTPSA id m8-20020aa78a08000000b0063ba9108c5csm4486023pfa.149.2023.05.22.10.35.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 22 May 2023 10:35:25 -0700 (PDT) Message-ID: <0b93be9554c21abfe9571ea9243fa5aa196d9200.camel@j-davis.com> Subject: Re: Order changes in PG16 since ICU introduction From: Jeff Davis To: Peter Eisentraut , Alvaro Herrera Cc: Sandro Santilli , Tom Lane , Regina Obe , pgsql-hackers@lists.postgresql.org Date: Mon, 22 May 2023 10:35:25 -0700 In-Reply-To: <05ad2b39-3d0f-e0aa-e0a3-086b998a26e8@enterprisedb.com> References: <20230509082553.yjikrxn54mi6hezc@alvherre.pgsql> <05ad2b39-3d0f-e0aa-e0a3-086b998a26e8@enterprisedb.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-05-11 at 13:07 +0200, Peter Eisentraut wrote: > Here is my proposed patch for this. The commit message makes it sound like lc_collate/ctype are completely obsolete, and I don't think that's quite right: they still represent the server environment, which does still matter in some cases. I'd just say that they are too confusing (likely to be misused), and becoming obsolete (or less relevant), or something along those lines. Otherwise, this is fine with me. I didn't do a detailed review because it's just mechanical. Regards, Jeff Davis