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: 'Shlok Kyal' <shlok(dot)kyal(dot)oss(at)gmail(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, 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-11-04 13:24:04
Message-ID: OS7PR01MB1831760FC266A4A518DAE8952F5682@OS7PR01MB18317.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Shlok,

Thanks for the review!

> 1. For all patches: Most of the comments for function in the file
> 'xact.c' is like of format:
> /*
> * Function name
> *
> * Function Description
> */
> Maybe we should follow the same for the functions added by these patches?

I do not have strong opinions for it, but added accordingly.

> 2. For patches for PG14 to PG18: In logical.c we can remove:
> +#include "access/genam.h"
> #include "access/xact.h"
>
> In logical.c we only introduced "ResetSystemTableScanState();" and
> this function which was declared 'access/xact.h'
> logical.c already includes access/xact.h

Fixed. It was included because functions are initially declared in genam.h.

> 3. For patches for PG 18 and PG 17: I noticed a unrelated line deletion change:
> #include "utils/snapmgr.h"
>
> -
> /* ----------------------------------------------------------------
>
> Was it intentional?

No, removed.

> 4. For patches for PG 14 and PG 15:
> + ALTER TABLE nested_sys_scan_test ALTER COLUMN checked_value set
> storage external;
> I think we should capitalize 'set storage external;'

+1. Fixed.

PSA new patch set.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachment Content-Type Size
nocfbot-v7-PG14-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 8.6 KB
nocfbot-v7-PG15-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 8.5 KB
nocfbot-v7-PG16-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 8.5 KB
nocfbot-v7-PG17-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 8.4 KB
nocfbot-v7-PG18-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 8.9 KB
nocfbot-v7-PG19-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 7.4 KB
v7-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 8.0 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2026-11-04 13:46:13 Re: BUG #19830: Mention that UNIQUE on a nondeterministic ICU collation treats ignorable characters as duplicates
Previous Message Shlok Kyal 2026-11-04 12:38:58 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)