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 1pZmlj-0005tA-3F for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Mar 2023 05:55:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pZmlh-0000Y1-TP for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Mar 2023 05:55:17 +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 1pZmlh-0000Uu-JI for pgsql-hackers@lists.postgresql.org; Wed, 08 Mar 2023 05:55:17 +0000 Received: from mail-pj1-x1030.google.com ([2607:f8b0:4864:20::1030]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pZmla-00057S-P6 for pgsql-hackers@postgresql.org; Wed, 08 Mar 2023 05:55:16 +0000 Received: by mail-pj1-x1030.google.com with SMTP id x34so15625577pjj.0 for ; Tue, 07 Mar 2023 21:55:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; t=1678254910; 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=+WJlKstB87s31XO265dAAfVP2rPM9AETJGtwf3YqRpI=; b=bwJmYINpa6SGzGnZGcWw8R2KB5cir/wWSlndBSKtSu/zCPh35++lpEaZAzCve2A5jE 2yKmRDpVIDAcaAr0buRjxfAD/yKnPs1bZ0yxDLOMMn5fsxjmLc3DMlD8PT5z6/poUYKm Eb5JnMxDLtI4HAzCc9X2KRI6+ayopyPcrTjYVGsvKL5d0mudhpDVq5Wl53LSmoqnbXAc 77Cqa0jvnM4Gq//qtc9hhnben92zMt6ZDBLIyyUzgxbVoUZFDOyfPJZygD1RkIKe7Mkd iSt6AwpDDtlucrmsfUnF1+/2Mkh+VkY9anJ5nChp0Xz5kL20hOcq7Jy3js+52DdR1uPk vEXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678254910; 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=+WJlKstB87s31XO265dAAfVP2rPM9AETJGtwf3YqRpI=; b=JOa1dsGvhgJ58k5Sit3q/LIkhowu9iYMt28VE+mKK0tfw86x2qXbEzwHsM8nCFmD6g sRp3I6F4VikUDolhjgf6eul7pDEush86U/VoEeMegBS9SkbQ0MOkQVhwqOTcGQUNrS7C vOgIQPpoI/RpF/rJqJVuRJxGRkPq8RlZ32sTji3S3SU2O9W1+NHnCHcOJJpubTNYhQyS Ttc6EuKV6Nt6zSPC5pU1L1o0gpLrhP8upmq/pFr/wZg+93fr7So+xs+J4ukga+aWm+QE jVllXB5QJvCgkWrUMdFFvEEMVN/zclWJ7fL/Jo1+CNlwnvPyld2IKM1KHMACz9b/QkqA nnUw== X-Gm-Message-State: AO0yUKXdCbdaXPSnSjMUWfcBFh/MBq47OcG8xDoSZk8B0o/0qc0sutff ftGc9CpaF0SVwD0HIqLVFW69Pg== X-Google-Smtp-Source: AK7set+vfKNd0WYqDD6cHy3f+xIpTiHEbBza6DCebuoHy/qGSWmWfRALROUaBvt5HrGyzxvfWGGsuQ== X-Received: by 2002:a17:902:db0f:b0:19e:7a2d:19f2 with SMTP id m15-20020a170902db0f00b0019e7a2d19f2mr22151411plx.19.1678254909755; Tue, 07 Mar 2023 21:55:09 -0800 (PST) Received: from jeff-laptop.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id b23-20020a170902d89700b0019a74841c9bsm9208564plz.192.2023.03.07.21.55.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 07 Mar 2023 21:55:09 -0800 (PST) Message-ID: <10bb0e53ba16e5865ea4d37575ee15d4df5dc043.camel@j-davis.com> Subject: Re: Move defaults toward ICU in 16? From: Jeff Davis To: Peter Eisentraut , Andres Freund , Bruce Momjian Cc: Tom Lane , Thomas Munro , Robert Haas , pgsql-hackers@postgresql.org, Heikki Linnakangas , Michael Meskes Date: Tue, 07 Mar 2023 21:55:07 -0800 In-Reply-To: <438b15cf88c9c5cf0cf1c24bf7b835d6362a8e0c.camel@j-davis.com> References: <5ffeafe843d43a975f31479fbd211ab88404841b.camel@j-davis.com> <20230211020042.uthdgj72kp3xlqam@awork3.anarazel.de> <20230214175957.idkb7shsqzp5nbll@awork3.anarazel.de> <2a7feb71dbdcea31478b3974b8075982ac2326d2.camel@j-davis.com> <20230217170523.ujnq3qr75rolfrmu@awork3.anarazel.de> <20230217180909.oqxjgjudbsofn666@awork3.anarazel.de> <3bf6b5517033947c134ed1ba9a325179a608bfd1.camel@j-davis.com> <20230217205009.4sy4lmmqanbhjsgb@awork3.anarazel.de> <558f794c351fb73596e4b05d96f66d01d56b4a50.camel@j-davis.com> <438b15cf88c9c5cf0cf1c24bf7b835d6362a8e0c.camel@j-davis.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-03-03 at 21:45 -0800, Jeff Davis wrote: > > > =C2=A0=C2=A0 0002: update template0 in new cluster (as described abov= e) I think 0002 is about ready and I plan to commit it soon unless someone has more comments. I'm holding off on 0001 for now, because you objected. But I still think 0001 is a good idea so I'd like to hear more before I withdraw it. > > > =C2=A0=C2=A0 0003: default initdb to use ICU This is also about ready, and I plan to commit this soon after 0002. > A different issue: unaccent is calling t_isspace(), which is just not > properly handling locales. t_isspace() always passes NULL as the last > argument to char2wchar. There are TODO comments throughout that file. I posted a bug report and patch for this issue: https://www.postgresql.org/message-id/79e4354d9eccfdb00483146a6b9f6295202e7= 890.camel@j-davis.com Regards, Jeff Davis