[Patch] Omit virtual generated columns from test_decoding output
SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
From: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-05-05T01:11:11Z
Lists: pgsql-hackers
Attachments
- 0001-Omit-virtual-generated-columns-from-test_decoding-ou.patch (application/octet-stream)
Hi Hackers, Virtual generated columns are not stored on disk, so heap_getattr() in tuple_to_stringinfo() always returned NULL for them, producing misleading output such as table public.t: INSERT: a[integer]:1 b[integer]:10 c[integer]:null even though the user could observe a non-null value via SELECT. Stored generated columns continue to be emitted as before because their values do live in the heap tuple. This matches the pgoutput's logicalrep_should_publish_column() which never publishes virtual generated columns. Added a regression test. Please find the patch attached. Thanks, Satya