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 1vrM1r-00GhPi-27 for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Feb 2026 20:14:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vrM1q-000CvQ-1T for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Feb 2026 20:14:10 +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 1vrM1q-000CvI-0e for pgsql-bugs@lists.postgresql.org; Sat, 14 Feb 2026 20:14:10 +0000 Received: from mail-dl1-x1234.google.com ([2607:f8b0:4864:20::1234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vrM1n-00000000dgw-1Swg for pgsql-bugs@lists.postgresql.org; Sat, 14 Feb 2026 20:14:08 +0000 Received: by mail-dl1-x1234.google.com with SMTP id a92af1059eb24-12739fe9a0eso49304c88.2 for ; Sat, 14 Feb 2026 12:14:08 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771100047; cv=none; d=google.com; s=arc-20240605; b=UmdeAdhV22oSG+PfO4fn60seRxf93pyOL3/cX6npOP6wcYEBMm0dndQiwLfM0hhYc7 QfjWZdGEunJye3qERolmHNFtdYOi4t6uIKw6ELN5skXZoIXN/99R/j7+y8Ghmx/FaoHh NQFV5IJD2ESlzPGf9NU44bRdPZKuN2Fx837+1l1XMSd3rwViUiLu8Iso1mQW+PPRw9m2 +H7NkKt8YyrDGF1r2lAunv+scRRxUkdFftWdrlTzAVYG6Xx7sBO+Ur0CHRarFyG2SraD qYRyqJhoPqNZu0LUcgzDQd3rp6o/Uf6Qu/+up9TxmUV+ZxMTvciMsry/NX3j1jdSVRE0 kgFg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=cmt56ssJ7rLguPK5HzYIkIaMKwfcr3R8NW+686RVEz4=; fh=crlEn7oZHksaErn/+jkPDhw+Fyr/2Q2q5aSB1cTS0I8=; b=AfFpu5qj9R8Yu2DxNvdzOu0nVtQ674HdNqRm8wC57rPkFckr79gek/TVWB0fHmfqU5 3jXBfVfhr1ij4RtyugHNt0ath8ItmLeJPL3bwCd8moZrUb9NMPdc1SLuc4tSCkVNPkAl g35tWBF/M6w2nMdh1ory3MteH1H1wot2xQpB+DfLbvd8rXWT76fkpawucSorV+y/Ob+1 InqafXPPuQfFuCbTgpqCIolvuRZRRQ2yl1wYrFYiX2MwHou3gCcuDsxqNQa/8YV5KB/9 V6apr2JB6na1qtjhAYCv7vCq3npg0J0rmEK/zVywm+72Q5M4sKC0wTCIAt0xSf0RB+gq mlbw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1771100047; x=1771704847; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=cmt56ssJ7rLguPK5HzYIkIaMKwfcr3R8NW+686RVEz4=; b=RSoi6XNyFB0IPjcL4DDLKqfD8lStShWyb5j/1WNyFs/SDW1yA3nJRx4n3I0aXc/ZoD 67hcIjifdagnbaj28XzeG6/OZtxvlBrNPCA6D26248KKn7jEd4ARkUUHFJo0KIt2bNjs xvOI9gyFYwp5mofuD8dLbzJERuR8J8snb4EmqV4fNSLWxGvXsWWV/3tH/qhK0c1RyoRW x7aWFE+XKkE+9l7Ijr0JnssVf2pjpcteBo643M0HiMbkIVKWQBp+pME4Zkt1o+jbfgyR dDZIU4w6wdXg/e7jmBXuv2ZHWiP58w7CADRhniLwzB4+23cy/IGHQEex8PHbfXd4wNm0 IeSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771100047; x=1771704847; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=cmt56ssJ7rLguPK5HzYIkIaMKwfcr3R8NW+686RVEz4=; b=mjXpjqNTDFVbietb5ArW/qy45COxril/KpOnZmNlp8rXKIo+EfelITfR+AQXmpefeC 0kRETdmStcU1bug6VKU36UcGoIjtCSDFc3jIxLw2xpURXOofR3EVqUF5kJ1hVPJxjDaX GslrMoZjy5X9/EvmVLKe6AlL0KxDcsp37ALJJ2PH/lW2+6L1WmoZGpH0Tev5Ub5YRCjV efI5iW4H+LAOoZF/KMeDCc9efnBttg3LVWU7JkkDHLiD+L/lobS2f3nwTk8vWyyL5hQN lOwN4DKZl7mbeWbrq3M2xYT0YdHB0hopP2TxrX+JiTES7iqLTAM3EJAy0u9oqiz3TuYX vnRA== X-Forwarded-Encrypted: i=1; AJvYcCUDthBxY7lt0I8cGvuiSTcETHnKs8wpStw6yZSmP79SVLmtWZAQ8Oi4Mb4yDHrm7hWFI4B0n8VEM8YR@lists.postgresql.org X-Gm-Message-State: AOJu0Yxw3y91+MYriORDZsuPPgTx2bvqPTd/pE62puIF1TMmA3JCvjdx faRjfWsXlN2zobl/JntbCWc8UYHdjQ00jfLTDM3xfeZGtFi7K4cQd0EJVyMflnkVhP69X5kXGUw g9lgousZ6CwCEiMRhIG1X0Rp+nlcUEho= X-Gm-Gg: AZuq6aKI7Alaq1cBHAkiWBBqKTnM38d1A3nsV5Dtg5ApZYDli7s01s8P7CmzmV2yfAB E/81/nmPFU5/zQOgcOc3z6UgI7lGRsxSCfBucMvBPuF44jMakF3zXw77CwMUKjK3x/Ew07MSm65 t17t6yyS7m9CPUJJZbIpbtGxAqtC5ym5PY7yOqOeYGYTFfvaCUWznsrIQojb5f3krjleUi4Pxgi IWS3C2X4NCL3Or/g2EBaBNdxdLl+NyRqGNlyzHvWW8VuBzrySA5fX3Ih7R74uFbSXzVyLo2WqbB qkYrzO7p/Pwlrio4eqjAoKmfwY+bd6aEM41JxmEiHPomKjGg209GFL4hAgx99Jm27w== X-Received: by 2002:a05:7022:920:b0:127:1186:812f with SMTP id a92af1059eb24-12739951fc4mr1372620c88.7.1771100046912; Sat, 14 Feb 2026 12:14:06 -0800 (PST) MIME-Version: 1.0 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> In-Reply-To: From: Thomas Munro Date: Sun, 15 Feb 2026 09:19:04 +1300 X-Gm-Features: AaiRm50ZVic5AMtMJIoDh24ObR82ywfa5_0cyFhAxdi93_HK4P9kz1X0NhsPudk Message-ID: Subject: Re: BUG #19406: substring(text) fails on valid UTF-8 toasted value in PostgreSQL 15.16 To: Noah Misch Cc: ranvis@gmail.com, pgsql-bugs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Also, LGTM.