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 1ppwyd-0002b5-UE for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 20:03:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppwyc-00062L-MY for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 20:03:26 +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 1ppwyc-00062B-DG for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 20:03:26 +0000 Received: from mail-pl1-x636.google.com ([2607:f8b0:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ppwyZ-004IcB-Sr for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 20:03:25 +0000 Received: by mail-pl1-x636.google.com with SMTP id d9443c01a7336-1a6762fd23cso23414915ad.3 for ; Fri, 21 Apr 2023 13:03:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1682107401; x=1684699401; 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=6eX99Iw8HGD6WmxO7UlwQx2Ll3O3OATyIT6AiaBqjgM=; b=rpAn4R5XyTO78InCYLiD3b8jMhEU1phRfwAYeWGbfl/H6mPuRCTnKR8GVVbl/4Mf9/ fuW2eQYcwi5K58PT6nPXyY30xoUvggwUORdHb/a0Zjs8oL9yXU9sOj7P4BC3N892RHZ2 ojl2uDWdvlG66I8y0Wz1glatvS5rR46/cD6ifDwppS/3NXjwlvX/e5MU5z4LGQjixWSJ depIzKk68LOlTJlUXO8WXp2+VqH/Dt+x3kCZ7fWSyNVoZvpZMG8gMGHiZl26daPzPDdq DbYM5GSrlZIDrK38K+1G3Ema1djOLYDcd5jHwZE25UYmEaojGMajOrIT/8vj55qXO/bB ffug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682107401; x=1684699401; 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=6eX99Iw8HGD6WmxO7UlwQx2Ll3O3OATyIT6AiaBqjgM=; b=jDbcgbJAETbuxkTdTUw+DwvU22ZzHo4QNYGNjoxdyVp4L8wrpTV646WzaIVL8J+tSN qKof8/z94vWQO4yMggmmFUAmauZ1BG+A7BAA3a8Qk0K2xDqPzYbutQwhcqRL64YV7IvP 2fuCONf1wKtY9UcCzjPaduSCbgcGrGyBk3qM4gLNHHCWjnaxwLKGuTFNLQgUJUoae7y2 2JEcIshULChQcJXE6Bol3YdqRO10D6Yq5M4MnOKh5r3A2D2QZk2lso8h09h3pjrALkn4 AiSzdOgzAS1FgqauVpNRO3wlhcCelyznMZZ9PfFhRcsUUVnv7sYqTGphS7+CZRNYAMpP /W+g== X-Gm-Message-State: AAQBX9em5iSWhnFeL/c66JTG+tQmKJ+YPxsmuZxJVOeAl4TOYdjzEUOc 78h2SoOb184TwlPGsCRTeI0YfQ== X-Google-Smtp-Source: AKy350bzAu9FTMFUw9ZNgEi2ct4zlzW5H4KacuxlFKo7jbgs+PxL49+K+zBTA9v3GwFY7j2sNSnApA== X-Received: by 2002:a17:902:e88c:b0:1a1:a830:cef8 with SMTP id w12-20020a170902e88c00b001a1a830cef8mr8441175plg.27.1682107401575; Fri, 21 Apr 2023 13:03:21 -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 y11-20020a170902864b00b001a285269b70sm3032491plt.280.2023.04.21.13.03.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 21 Apr 2023 13:03:20 -0700 (PDT) Message-ID: <3384e55c39993b23c19bed538f39721b68f797f9.camel@j-davis.com> Subject: Re: Order changes in PG16 since ICU introduction From: Jeff Davis To: Sandro Santilli , Peter Eisentraut Cc: Tom Lane , Regina Obe , pgsql-hackers@lists.postgresql.org Date: Fri, 21 Apr 2023 13:03:19 -0700 In-Reply-To: References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> <533d93c5-f604-8e5f-4a48-975c08c53d59@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 Fri, 2023-04-21 at 21:14 +0200, Sandro Santilli wrote: > And then runs: >=20 > =C2=A0 createdb --encoding=3DUTF-8 --template=3Dtemplate0 --lc-collate=3D= C=20 >=20 > Should we tweak anything else to make the results predictable ? You can specify --locale-provider=3Dlibc Regards, Jeff Davis