Re: BUG: SUBSTRING on TOASTed text returns "invalid byte sequence for encoding UTF8: 0xc3" - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG: SUBSTRING on TOASTed text returns "invalid byte sequence for encoding UTF8: 0xc3"
Date
Msg-id CAKFQuwYoHhmPDidGODjCmbs7uDXZePZz=ue4J0YcCjKi_GzYzw@mail.gmail.com
Whole thread
In response to BUG: SUBSTRING on TOASTed text returns "invalid byte sequence for encoding UTF8: 0xc3"  (ludovitkramar <ludovitkramar@proton.me>)
List pgsql-bugs
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.


David J.

pgsql-bugs by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: BUG #19393: pg_upgrade fails with duplicate key violation when CHECK constraint named *_not_null exists
Next
From: Laurenz Albe
Date:
Subject: Re: BUG #19393: pg_upgrade fails with duplicate key violation when CHECK constraint named *_not_null exists