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 1vvFQl-00AL2e-1S for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Feb 2026 13:59:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvFQk-006YD7-1K for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Feb 2026 13:59:58 +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 1vvFQk-006YCt-0W for pgsql-bugs@lists.postgresql.org; Wed, 25 Feb 2026 13:59:58 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvFQh-000000017yA-0wU5 for pgsql-bugs@lists.postgresql.org; Wed, 25 Feb 2026 13:59:57 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-6729292dcd7so3395225eaf.0 for ; Wed, 25 Feb 2026 05:59:56 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772027996; cv=none; d=google.com; s=arc-20240605; b=XzQCQ/b4Z8F5syDRbwf6vVNqh9HMo9Dk8SwfiJULgk5OoQxKUhhx5OiKogdfX4/LA7 cvFa4aHukhLP33ER/JJerfaYmT4G3KwH27H6haz2tN3JFuABjIcHf1/7SQ7jigbxy7Ns Tm6nmcclJn76QEPW5bx82Dhp42Ul8HqfcXST2vxiIZGsKjHAEAt9Z70Xawd/1FrNWKU+ nqPQIfqF6mVQySv301rmUke4CtBV3FwgU8jqaeycyjFVpEw/27n8mN3OTWRU8FEJk5Zh o3WxWQFr/uEiBN1jx70WdcmeS0gN/NetQ0IFxzfyglJ0JDw/DDnFLeausTc/enYPqZwC 3/cQ== 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:references:in-reply-to :mime-version:dkim-signature; bh=0xvBuDXcCAZRS2Z0UFV7i4kk6KXLlzpEWGx08Qfq6ck=; fh=Q5VfWtYycz60g+lmXbEkaw+sbpXGrgbko4EwYiN0hF8=; b=T7ZSS2KbdLMR4IaVA9UhlDjNsxAtz4ggp1mGzrLsq5cvykyT2B8zny9ABKsioLSjZg KqIjcmr/GHprEp7KnauzEALhw819N4HQno6HPo2xfY3132QmwkgdrCeiTQyaq7n8gcG5 YMmZgyC45L50rs9iST5++piqzaRxnoOjo5PRhA70bku4XjeEJQSqTOgZEB9bjtSgVq/G KZyGDqHPZarFEVBOTGq7RcOgXsMd0/quTYmb+a05biRDP/1A5aaAjjg87lm8k46oGQxj 6bnsrGmCr9RAFn9we3SdUWDjwCEvpX663LvVi2YGAfPylC54bBegzHaTrmcJvvbBdsMi sPcw==; 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=1772027996; x=1772632796; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=0xvBuDXcCAZRS2Z0UFV7i4kk6KXLlzpEWGx08Qfq6ck=; b=h37oXTTkiztTg2gXw3usfn/pBWsb9FHLggNZHf7cuwCiEa01idtPNPldZDLPAnMCZq w0IfHKjlEKqh9XFMlfwX9EQLC0Ui/Vx8YRJJY68zTWgT5ZSRwoZtKL0rlias0otE39K0 5zKeMzVVnBkPZ0W/X3NDGYb2VqDUBlUvf+EfCCkQotbDv2GSKvOWSQz/xpjibVTzLURx VEGhGvOc3gpSVgnahRNbIXCPsoYmWqCvTCeSloDDVxvhrPxYmH8RJGSn71kYljnwEkB5 bIN3E4aPjTfWK5l4VinvBPaVLV590kHkG5RJX1AfIT6qmhqk/5ABtXjzcjwY9xY6NWP7 9n6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772027996; x=1772632796; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=0xvBuDXcCAZRS2Z0UFV7i4kk6KXLlzpEWGx08Qfq6ck=; b=Q2oLEGcHvWtDAcFlt+g63KW3DgkW5t4H+UBuWKp/IT28Ckbd3LC5H2YmQJa6WZKbqF Tv6fQdjaxfYktmHFns2wPiO93B/qQi5cWVG22tozFlsGXZ4wP3ufbLp9dsnod+t3Rw/X NvRP3EkNSp5jorGHuD3sJ85jK8zazNRTmH1SEdtmco/ELLR5VuJ8DQMZ8jH38cSGECZk y9o2A3mTOfoY3QRc2JRIylJzOrYHViBcB/vOtfdwkJvTurql0IW3gxm9J7FdNveXBo6L AmnIFJpE0lTrNdu4jnXZthWB9JwhCZIAbUNYLR29nxnEPjq0yPMoAb4xloFuyxvnpX59 Lssg== X-Gm-Message-State: AOJu0YxyfP+vOpsVarnQXstdgLlkLT3iMtJfRkIVNA+rrD1VrDwjERJw gtb+EIVzNb8UvVCVo+CQ44137EW5JJODHQXugtwsK34X77hOZzS3oDv6B3KwwH3du7sfwHB/HDG u+Chm/GwpROrOFLfiBc7a3qcWwXoPneSBFQ== X-Gm-Gg: ATEYQzwJMCZfYhwumL5XUcyCLPZWPcXhlpg5alb+AYnNSEXd3o1F3mQOh5RpYn53cE5 f+P9yk4dfmYxvkkvum8/6IlhT1cVjm298UeiG+y0dYXWuobvSWkaeg/oaQEsLYP2OS20sySEYDl HheETnnSBuLd657pOYog2SKH84HWcsFe5pEashUl1ZE5gLrlrS9HcAxtQ4dHNxmLyqv4a3xhhlS h5nFI/vXdgu4ShxGGHUOKg9a1YeYEG2Z4SFP8kDObiD5yY9ImCNCSXJYuSDWKGW7dEwhALcAOef gnIbHXE= X-Received: by 2002:a05:6870:b92:b0:409:62ce:83f8 with SMTP id 586e51a60fabf-4157ac6aacemr8324791fac.13.1772027995690; Wed, 25 Feb 2026 05:59:55 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:4585:10b0:619:bb02:7065 with HTTP; Wed, 25 Feb 2026 05:59:54 -0800 (PST) In-Reply-To: <9e005eef-a5dc-4ca3-8589-d7836c459e4d@4vrs.com> References: <9e005eef-a5dc-4ca3-8589-d7836c459e4d@4vrs.com> From: "David G. Johnston" Date: Wed, 25 Feb 2026 06:59:54 -0700 X-Gm-Features: AaiRm53AUbzMCo9oroCUP1KLi41nxUFkzwfkliblbcg9AwDlBelpD5DF1xwRGVk Message-ID: Subject: Re: BugReport: PostgreSQL 17.8. Processing UTF8 encoded strings To: Vladimir Valikaev Cc: "pgsql-bugs@lists.postgresql.org" , Victor Sudakov , Eugene Nasonkin Content-Type: multipart/alternative; boundary="000000000000371cea064ba66bfa" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000371cea064ba66bfa Content-Type: text/plain; charset="UTF-8" On Tuesday, February 24, 2026, Vladimir Valikaev wrote: > > After updating PostgreSQL from version 17.7 to 17.8, we encountered a > problem when extracting a substring from a UTF8 encoded string: > *ERROR: invalid byte sequence for encoding "UTF8": 0xe2* > > This should be fixed in tomorrows out-of-cycle release. https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-february-26-2026-3241/ David J. --000000000000371cea064ba66bfa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, February 24, 2026, Vladimir Valikaev <vladimir@4vrs.com> wrote:

After updating PostgreSQL from version 17.7 to 17.8, we encountered a problem when extracting a substring from a UTF8 encoded string:
ERROR:=C2=A0 invalid byte sequence for encoding "UTF8": = 0xe2

This should be fixed in tomorrow= s out-of-cycle release.


David J.=

--000000000000371cea064ba66bfa--