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: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: 'Peter Smith' <smithpb2250(at)gmail(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 06:42:22
Message-ID: OS7PR01MB18317A05F215BBCB42AE6609FF5602@OS7PR01MB18317.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Peter,

> 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;

Good point, it can be removed by providing few functions. v5 did the same.
We need to keep bsysscan anyway for back branches, so the patch shape for them
is slightly different, see v5-PG18.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachment Content-Type Size
v5-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 7.9 KB
nocfbot-v5-PG18-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 9.1 KB
nocfbot-v5-PG19-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 7.2 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Narayanan Venkateswaran 2026-10-27 06:51:44 Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses
Previous Message Tender Wang 2026-10-27 06:35:42 Re: BUG #19798: "failed to build any 4-way joins" with ROLLUP over a LATERAL subquery that references the nullable s