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 1ppvGk-0004LF-ML for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 18:14:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppvGi-00031O-IN for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 18:14:00 +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 1ppvGi-00031F-8a for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 18:14:00 +0000 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ppvGf-004HeM-GH for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 18:13:59 +0000 Received: by mail-qt1-x832.google.com with SMTP id d75a77b69052e-3ef33a83ff1so10658091cf.1 for ; Fri, 21 Apr 2023 11:13:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pcorp-us.20221208.gappssmtp.com; s=20221208; t=1682100835; x=1684692835; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:cc:to :from:from:to:cc:subject:date:message-id:reply-to; bh=qwiGeFDBCDq54/aCYI4d0XSsgkUb9FHx7ndN+uJVyV4=; b=d8Jvg60HwXOr7lUt9BgoTC+C/7VHKXr1IDOcKFGsa0M/ylgmbS+95wD/BDU9zIQHOT 0/gmlevRBpc6l/u+wd0aPxtF3zxaqIq1Y4E3q/chcRQci8kIc39zboVmrk3BUnLWOIXZ eNePMRVJVjx/9QpZ7UdSqQP71VZVOQmEmDrawHp1BXJ/7rHvaunb037zF2THD8Um4tcc cKlHPuO5khRidGVJNFQxM+lXAuO5YIm+sEQ1wt+AT73k2SUr5FOAEZXsvm62MDCZCh3P rVaKyk1ensL4mBDuycMhIACuTs0hX5qPS5+ixv/Ccn0/keRxTMs/79lNoxl+P1XVW9Cz ya6w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682100835; x=1684692835; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:cc:to :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=qwiGeFDBCDq54/aCYI4d0XSsgkUb9FHx7ndN+uJVyV4=; b=kSzM9T42++f6F6oqERjaNLuiSLDbwsAN/s6FXOBULwWra2KGmXmitZ+pwh0sOD3Urw 22KRq9ZAICEupCK4x396UnFrrSwfnzhV9Zb8IMRUn/jlKt2m+ywVBRVWOMH7xc6gWW8+ +ZEwOE8WpVnVvmXQfa8QwSnNv76Kx4GuU9VCFVnN6An++ee00VRlnSzKpCNnle9hJ1To p8As8HkN1/h/hplNiWBYYD+PMUm4bJS3r72cb9Of7W2BbyftVpMGt7UlPZJ31JXQ1uTw c8lJQM2TWZo+gDH9JdByTH88EHlHONFWl3t62bXq0KQdm5r6R7b3s53eJG/lF91CKYcX zWPA== X-Gm-Message-State: AAQBX9eVF0u9wqcwvxYy1066YNtxcEZyDBfHm2vVmhoR3GJLrzPtq7xM Fze+8mkcx0/Ew1nWYr9keyrEAg== X-Google-Smtp-Source: AKy350YOzfpqFc36VUOvYfHxjjZAVNfhenprCUqcvkvZsN9Z1agDH39sHbx3bn0Bj6GWMz87aPBKXg== X-Received: by 2002:a05:622a:1a8d:b0:3ef:5add:2c7c with SMTP id s13-20020a05622a1a8d00b003ef5add2c7cmr6306243qtc.58.1682100835598; Fri, 21 Apr 2023 11:13:55 -0700 (PDT) Received: from F ([208.127.183.82]) by smtp.gmail.com with ESMTPSA id ef7-20020a05620a808700b007486d9fa1d7sm1492980qkb.95.2023.04.21.11.13.51 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 21 Apr 2023 11:13:52 -0700 (PDT) From: "Regina Obe" To: "'Tom Lane'" Cc: "'Peter Eisentraut'" , "'Sandro Santilli'" , , "'Jeff Davis'" References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> <533d93c5-f604-8e5f-4a48-975c08c53d59@enterprisedb.com> <3365333.1682098091@sss.pgh.pa.us> <002d01d97477$f0395640$d0ac02c0$@pcorp.us> <3367226.1682099185@sss.pgh.pa.us> <003b01d9747a$910471c0$b30d5540$@pcorp.us> <3368986.1682099982@sss.pgh.pa.us> In-Reply-To: <3368986.1682099982@sss.pgh.pa.us> Subject: RE: Order changes in PG16 since ICU introduction Date: Fri, 21 Apr 2023 14:13:49 -0400 Message-ID: <000001d9747d$066b7560$13426020$@pcorp.us> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQGxk+8S/MfoZUDGLFz42A+I7+xfAAHR8HzHAhsEYz4Bynr6awHasdxCAp1gB3YBWXyFzQLG6LzIAu8ooamu+9klcA== Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Yeah. My recommendation is just LOCALE: > > regression=# CREATE DATABASE test1 TEMPLATE=template0 ENCODING = > 'UTF8' LOCALE = 'C'; CREATE DATABASE regression=# CREATE DATABASE test2 > TEMPLATE=template0 ENCODING = 'UTF8' ICU_LOCALE = 'C'; > NOTICE: using standard form "en-US-u-va-posix" for locale "C" > CREATE DATABASE > > I think it's probably intentional that ICU_LOCALE is stricter about being given > a real ICU locale name, but I didn't write any of that code. > > regards, tom lane CREATE DATABASE test1 TEMPLATE=template0 ENCODING = 'UTF8' LOCALE = 'C'; Doesn't seem to work at least not under mingw64 anyway. SELECT '+' < '-' ; Returns false