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 1sUUNK-003QIU-Mp for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jul 2024 16:53:02 +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 1sUUNI-001Tgh-8S for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jul 2024 16:53:00 +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 1sUUNH-001TgY-Qe for pgsql-hackers@lists.postgresql.org; Thu, 18 Jul 2024 16:53:00 +0000 Received: from mail-pf1-x436.google.com ([2607:f8b0:4864:20::436]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sUUN9-000EPJ-N3 for pgsql-hackers@postgresql.org; Thu, 18 Jul 2024 16:52:59 +0000 Received: by mail-pf1-x436.google.com with SMTP id d2e1a72fcca58-70b0d0fefe3so40219b3a.2 for ; Thu, 18 Jul 2024 09:52:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1721321567; x=1721926367; darn=postgresql.org; 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=U0vS9fBrljD693JwjeBYAjdb/zbMeqjDEmlOQwzZ0tY=; b=O3xkzWHcQiNLgTAjpL8bkC0fLZI4yLvxi2Rpivm5XSZXM6xTBdUSKZfYp6KTA5+X5f Bc+LcpT+MzTr9RcqiwhtiK77jHEwPFhbuTweZ9IRIlDn0Kvivuwr2Qkj90rd7xN5VsgD iuULwxm9jnnhxVSkY1JpMla60FrBgpDUQz1IEd50Peqi5FuJDMEb1ADbsrfrTob9PWnq B6poY5h0lLQaJcC4DZurfbXLPGkBorp3xr4O3nj9e5O4llvnN04QyG7wn4GynvNFMiHy zywWLjI8Uh3JP5qfk5BxvxpX7dpvoJ2W5IJVDFbZW4YSSNoEBdfgTrY0edoQTh6J/vg1 3jyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721321567; x=1721926367; 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=U0vS9fBrljD693JwjeBYAjdb/zbMeqjDEmlOQwzZ0tY=; b=HMsvx7jN/Et61JE6GSKGYOfyi/bQhxRFIs0ZLLg6mhpoCWWteFQXmehDgKrxDbBSA2 BdPfsLzqCqX1AFhoLFu6B3W97zY0VBPcQHpM06kVNe1jdvAlERS3UmmBx/tEA4u4lZ93 1iZB6W6Kun/7lc8CR/dgU+pvgN5CAgl35KZRusFoDFs0zE4jdpfRs4T/CqVRCQyPg42B FeYSmXfcVU5tv6Zysly4KuxcJApeqF45BHsBS4divEsSIqvXXIOBDHGlLcvYp6DXT1YI 7TAeVStNtlsKxmBpqXE+xlL/qkmohllrBDPFR27SH0zZs/AQuFhbJGyL8/Se/tZTIQC7 1oiA== X-Forwarded-Encrypted: i=1; AJvYcCUAmxA3H6Gh3+GAdYjTgESf0qmwMCVy9e3iAi0280Hu9NnRn91DOE119xvcrYwanbTS7LhM6ioqEsz8mLUITWlWCLDeRYuBPjTYnOes X-Gm-Message-State: AOJu0YxJYS9mVzf4A2bPQ5plLPKRm0MbFApLVmI9+0WruCkEOF8GYiq/ xyQ84CICNbAP8sZ9dmmDTE4/Ql68O3iW1uofGc3uuhYfVEc8DfSHNQ7+3xrLnQ== X-Google-Smtp-Source: AGHT+IEubvXYX0tE58fjQgIXkf1rlymxhifr0oYyVa1ysjVanc6GLXHh2TsnqAfD8Bv74JiYy4Fc7w== X-Received: by 2002:a05:6a00:c92:b0:70b:122c:856 with SMTP id d2e1a72fcca58-70ce4f3f0c4mr5550797b3a.31.1721321566751; Thu, 18 Jul 2024 09:52:46 -0700 (PDT) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-70cfc81d826sm39131b3a.149.2024.07.18.09.52.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 18 Jul 2024 09:52:46 -0700 (PDT) Message-ID: Subject: Re: Built-in CTYPE provider From: Jeff Davis To: Noah Misch , Laurenz Albe Cc: Peter Eisentraut , Daniel Verite , Jeremy Schneider , Tom Lane , Robert Haas , pgsql-hackers@postgresql.org Date: Thu, 18 Jul 2024 09:52:44 -0700 In-Reply-To: <20240718140015.9b.nmisch@google.com> 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> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2024-07-18 at 07:00 -0700, Noah Misch wrote: > Given all the messages on this thread, if the feature remains in > PostgreSQL, I > advise you to be ready to tolerate PostgreSQL "routinely updating the > built-in > provider to adopt any changes that Unicode makes". You mean messages from me, like: * "I have no intention force a Unicode update" [1] * "While nothing needs to be changed for 17, I agree that we may need to be careful in future releases not to break things." [2] * "...you are right that we may need to freeze Unicode updates or be more precise about versioning..." [2] * "If you are proposing that Unicode updates should not be performed if they affect the results of any IMMUTABLE function...I am neither endorsing nor opposing..." [3] ? The only source I can imagine for your concern -- please correct me if I'm wrong -- is that I declined to make a preemptive version 18 promise deep in this version 17 Open Item subthread. But I have good reasons. First, if we promise not to update Unicode, that would also affect NORMALIZE(), so for the sake of transparency we need a top-level discussion. Second, an Open Item should be tightly scoped to what actually needs to happen in version 17 before release. And thirdly, such a promise would artificially limit the range of possible outcomes, which may include various compromises that are not 17 material. I'm perplexed as to why you don't engage in the version 18 policy discussion. > =C2=A0 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. Regards, Jeff Davis [1]=20 https://www.postgresql.org/message-id/5edb38923b0b23eb643f61807ef772a237ab9= 2cf.camel%40j-davis.com [2] https://www.postgresql.org/message-id/db496682c6656ac64433f05f8821e561bbf4d= 105.camel@j-davis.com [3] https://www.postgresql.org/message-id/1d178eb1bbd61da1bcfe4a11d6545e9cdcede= 1d1.camel%40j-davis.com