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.96) (envelope-from ) id 1vrOPG-001GLB-06 for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Feb 2026 22:46:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vrOPD-000Qwx-2v for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Feb 2026 22:46:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vrOPD-000Qwo-1M for pgsql-bugs@lists.postgresql.org; Sat, 14 Feb 2026 22:46:27 +0000 Received: from mail-dy1-x1331.google.com ([2607:f8b0:4864:20::1331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vrOPA-00000000edT-3Zns for pgsql-bugs@lists.postgresql.org; Sat, 14 Feb 2026 22:46:26 +0000 Received: by mail-dy1-x1331.google.com with SMTP id 5a478bee46e88-2b740872a01so4204751eec.1 for ; Sat, 14 Feb 2026 14:46:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1771109184; x=1771713984; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=SvoK3atXTMO4xklPII7Dcn0NJ3axjwiK05l3SXbgWR8=; b=cP7SG9dFu7c4/sxzaY0VWH84ULjU5C1po9KruJZLX089kI80bytXt0exIV3YEI32/k S6nAIiBBAD+SDlxx32bqjnekG+S23U/tg7HxbwUb8+sqwpmfxJo0IRc07+ZAz1OOu9ae oR/Hm8bItrl3DtAvqe0aMHbgfvzHVHly4muoI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771109184; x=1771713984; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=SvoK3atXTMO4xklPII7Dcn0NJ3axjwiK05l3SXbgWR8=; b=wGR/dsW6UnTLOFEDLx1KHWeup1CzdiX+hxOPuCFw/LltHol1fuaFE64Am8QunPwVEK 1oKZ8B3WDi6AOHfj73P+j/hA1dmpCqy0AXcgXqWwc5icIbMLqPJw6wti4gAR2BB2Zq+y gUWZDDXw4uwd5yCnKV2hy2+B3stKYnlNGyBbaKrxzHfU/nRrphy7i+Q7sPDBuc4nH/14 qIFahELkn4dv51abdiEwFWuIGpmNYaMJJRKkpMtOq/D/UHsxuhEwZimDXJjPOsfxxbch 5tp/AN/Ol63IX5b551dFjsRweuUfClcken30eZLE2eYZfRVav4aiAbNuYwtQ72rzJFIP PdtA== X-Forwarded-Encrypted: i=1; AJvYcCVUotOn/DjV3/OAvZsMk6GiqWHwtTeSm2r++4icf40Rv1Xs2uNHMMxoipF3MQpIfQfWc/GCwNdgpxDc@lists.postgresql.org X-Gm-Message-State: AOJu0Yy0ifytEqm+CYnBrmj84OZI+d9KSrsdR1Ds0me7zafi6Gr/9ZEY XcjrFFSx67m1xEaPxwQRaNGEmxSR8PnrvuIj9Ap3tyWqFjHqfmxe+ukFnQCGesQ8cA== X-Gm-Gg: AZuq6aIL9hlm7D8xNiTgggIbueL9hp1+J8SDTe81H4DzVsmXKtJV6ctKGSL9nBL/qU9 Jl7nw1ai5MIn0pfT3+kmOrMTpCeSPU1fvQmv4kSfBsRI025DtfN2MfiSwE/znsAkBz1TCyo8n6n LAfB8QbFGa+ANrBx89Zb2nizhaSy5ULL5ZoT57hk8oMkJFpTew3Xb78eM/mG0I2gOpm8OrG+RFo HFPS8SqkKOX5ewTXIcDB25+89LhFhzPwzbQ5Y3MGTtKxuQ2DFBbv7j8j3SuUMETmIMgYyViC01c A0WWuhqFzan31Xz0XZ+AjHQPbu73AdR8xKUI/z8DSK9nufX0eucZDtTAlmKX60ijO+K2tqVE17E HEdNCV1MlSqbRQpUp13E/5S9Kd2BfodNFwP1ELUhlI1gW9xY2WbqLTUuGv86toQw8vIY04iRjJS ZaTxQesLLmI6iqg+y1ca2nMKfq3kTi3v5GEeyKQmA2bKmVTEx79tdS8AU= X-Received: by 2002:a05:7300:a54c:b0:2ba:a712:51e3 with SMTP id 5a478bee46e88-2babc46f20fmr2784845eec.21.1771109183873; Sat, 14 Feb 2026 14:46:23 -0800 (PST) Received: from microsoft.com (c-73-15-160-255.hsd1.ca.comcast.net. [73.15.160.255]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2bacb543d4dsm3746906eec.7.2026.02.14.14.46.23 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 14 Feb 2026 14:46:23 -0800 (PST) Date: Sat, 14 Feb 2026 14:46:21 -0800 From: Noah Misch To: Thomas Munro Cc: ranvis@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19406: substring(text) fails on valid UTF-8 toasted value in PostgreSQL 15.16 Message-ID: <20260214224621.26.noahmisch@microsoft.com> References: <19406-9867fddddd724fca@postgresql.org> <20260213172702.71@rfd.leadboat.com> <20260213224804.2c@rfd.leadboat.com> <20260214002113.1f.noahmisch@microsoft.com> <20260214053821.fa.noahmisch@microsoft.com> <20260214193344.48@rfd.leadboat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, Feb 15, 2026 at 09:19:04AM +1300, Thomas Munro wrote: > Also, LGTM. Pushed as commit 9f4fd11