Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
Cc: Jiří Kavalík <jiri(dot)kavalik(at)comgate(dot)cz>, Zhijie Hou <houzhijie22(at)gmail(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)
Date: 2026-10-27 03:36:31
Message-ID: CAHut+Pt+eFDYw=u=B4zSa0iN=XaOa1quCfY-Xg2+=y6r-sxQ8w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Oct 27, 2026 at 12:25 AM Hayato Kuroda (Fujitsu)
<kuroda(dot)hayato(at)fujitsu(dot)com> wrote:
>
> Hi members,
>
> I made a patch set for supported branches. I confirmed the error can happen
> and the patch can address the issue on PG14-PG18.
>
> I refactored the test code for the readability. Wondering PG19/HEAD should contain
> the test, because the reported ERROR could not happen in the first place.
>

Hi Kuroda-San,

Since you are refactoring this flag anyway, would it be better to try
to eliminate the global-variable completely? e.g. expose the same
information by some accessor function.

-extern PGDLLIMPORT bool bsysscan;
+extern PGDLLIMPORT int sysscan_depth;

======
Kind Regards,
Peter Smith.
Fujitsu Australia.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nitin Motiani 2026-10-27 03:59:44 Re: BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date
Previous Message Tender Wang 2026-10-27 03:27:39 Re: BUG #19799: Self-join elimination: "failed to build any 3-way joins" with LATERAL