Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUUY7-003RDm-SJ for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jul 2024 17:04:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sUUY5-001afA-Lv for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jul 2024 17:04:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUUY5-001af2-CI for pgsql-hackers@lists.postgresql.org; Thu, 18 Jul 2024 17:04:09 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUUY3-000ETk-P0 for pgsql-hackers@postgresql.org; Thu, 18 Jul 2024 17:04:09 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 46IH3V6i3729437; Thu, 18 Jul 2024 13:03:31 -0400 From: Tom Lane To: Jeff Davis cc: Noah Misch , Laurenz Albe , Peter Eisentraut , Daniel Verite , Jeremy Schneider , Robert Haas , pgsql-hackers@postgresql.org Subject: Re: Built-in CTYPE provider In-reply-to: References: <20240704212641.c4.nmisch@google.com> <1d178eb1bbd61da1bcfe4a11d6545e9cdcede1d1.camel@j-davis.com> <20240706195129.fd@rfd.leadboat.com> <564325.1720297161@sss.pgh.pa.us> <20240709010545.8c.nmisch@google.com> <39a30bd36198b44ed40da271ef96a72d133c32ba.camel@j-davis.com> <20240711125040.11.nmisch@google.com> <1908b19c0a3a210935608635cad1b4eeb819c66f.camel@j-davis.com> <20240717220326.df.nmisch@google.com> <4efae9f992f96a1e8eba0f515c637c3ff252d0fc.camel@cybertec.at> <20240718140015.9b.nmisch@google.com> Comments: In-reply-to Jeff Davis message dated "Thu, 18 Jul 2024 09:52:44 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3729435.1721322211.1@sss.pgh.pa.us> Date: Thu, 18 Jul 2024 13:03:31 -0400 Message-ID: <3729436.1721322211@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Jeff Davis writes: > On Thu, 2024-07-18 at 07:00 -0700, Noah Misch wrote: >> Maybe someone will change >> something in v18 so it's not like that, but don't count on it. > That's backwards. If nothing happens in v18, then there will be no > breaking Unicode change. It takes an active step by a committer to > update Unicode. This whole discussion seems quite bizarre to me. In the first place, it is certain that Unicode will continue to evolve, and I can't believe that we'd just freeze pg_c_utf8 on the current definition forever. Whether the first change happens in v18 or years later doesn't seem like a particularly critical point. In the second place, I cannot understand why pg_c_utf8 is being held to a mutability standard that we have never applied to any other locale-related functionality --- and indeed could not do so, since in most cases that functionality has been buried in libraries we don't control. It seems to me to be already a great step forward that with pg_c_utf8, at least we can guarantee that the behavior won't change without us knowing about it. Noah's desire to revert the feature makes the mutability situation strictly worse, because people will have to continue to rely on OS-provided functionality that can change at any time. regards, tom lane