MIME-Version: 1.0
In-Reply-To: <ANM2Wyhl66VMeL4PfgAA4Quozz-NM9Q3j0OFpyxDIwlUQ8392QerkipA3xniJ7GaJIKF3Gd6X1wDw95bXkdP_8VdFK5etQmb1AoDkzvbAak=@proton.me>
References: <ANM2Wyhl66VMeL4PfgAA4Quozz-NM9Q3j0OFpyxDIwlUQ8392QerkipA3xniJ7GaJIKF3Gd6X1wDw95bXkdP_8VdFK5etQmb1AoDkzvbAak=@proton.me>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 21 Feb 2026 08:05:06 -0700
Message-ID: <CAKFQuwYoHhmPDidGODjCmbs7uDXZePZz=ue4J0YcCjKi_GzYzw@mail.gmail.com>
Subject: Re: BUG: SUBSTRING on TOASTed text returns "invalid byte sequence for
 encoding UTF8: 0xc3"
To: ludovitkramar <ludovitkramar@proton.me>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fc16dd064b56dc23"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYoHhmPDidGODjCmbs7uDXZePZz%3Due4J0YcCjKi_GzYzw%40mail.gmail.com>
Precedence: bulk

--000000000000fc16dd064b56dc23
Content-Type: text/plain; charset="UTF-8"

On Friday, February 20, 2026, ludovitkramar <ludovitkramar@proton.me> wrote:

> Disclosure: This bug reproduction and report were generated with the
> assistance of Claude Opus 4.6, and reviewed by me.
>
>
> PostgreSQL version: 18.2-1 (Arch Linux package)
>
> SELECT version();
>   PostgreSQL 18.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 15.2.1
> 20260209, 64-bit
>

You should modify your prompt to include looking for current news and bug
reports on the PostgreSQL website before writing up a new report.


https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-february-26-2026-3241/

David J.

--000000000000fc16dd064b56dc23
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Friday, February 20, 2026, ludovitkramar &lt;<a href=3D"mailto:ludovitkr=
amar@proton.me">ludovitkramar@proton.me</a>&gt; wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div style=3D"font-family:Arial,sans-serif;font-size:14px"><s=
pan><div style=3D"background-color:rgb(255,255,255)"><span>Disclosure: This=
 bug reproduction and report were generated with the</span></div><span styl=
e=3D"background-color:rgb(255,255,255)"><span>assistance of Claude Opus 4.6=
, and reviewed by me.</span></span><br></span></div><div style=3D"font-fami=
ly:Arial,sans-serif;font-size:14px"><span><span style=3D"background-color:r=
gb(255,255,255)"><span><br></span></span></span></div><div style=3D"font-fa=
mily:Arial,sans-serif;font-size:14px"><span><br></span></div><div style=3D"=
font-family:Arial,sans-serif;font-size:14px"><span>PostgreSQL version: 18.2=
-1 (Arch Linux package)</span><div><br></div><div><span>SELECT version();</=
span></div><div><span>=C2=A0 PostgreSQL 18.2 on x86_64-pc-linux-gnu, compil=
ed by gcc (GCC) 15.2.1 20260209, 64-bit</span></div><div></div></div></bloc=
kquote><div><br></div><div>You should modify your prompt to include looking=
 for current news and bug reports on the PostgreSQL website before writing =
up a new report.</div><div><br></div><div>=C2=A0<a href=3D"https://www.post=
gresql.org/about/news/out-of-cycle-release-scheduled-for-february-26-2026-3=
241/">https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-=
for-february-26-2026-3241/</a></div><div><br></div><div>David J.</div><div>=
<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bord=
er-left:1px #ccc solid;padding-left:1ex">
<div style=3D"font-family:Arial,sans-serif;font-size:14px">
    <div>
       =20
            </div>
   =20
            <div>
       =20
            </div>
</div>
</blockquote>

--000000000000fc16dd064b56dc23--