Allow logical decoding to output generated columns

Edit
ID 5068
Title Allow logical decoding to output generated columns
Topic Replication & Recovery
Created 2024-06-23 04:26:36
Last modified 2024-10-08 03:23:39 (1 month, 3 weeks ago)
Latest email 2024-11-07 10:16:54 (3 weeks, 5 days ago)
Status
2024-11: Waiting on Author
2024-09: Moved to next CF
2024-07: Moved to next CF
Target version 18
Authors Peter Smith (smithpb2250), Shubham Khanna (skhanna), Shlok Kyal (shlokkyal)
Reviewers Masahiko Sawada (masahikosawada), Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5068
git checkout commitfest/cf/5068
Emails
Pgoutput not capturing the generated columns
First at 2023-08-01 06:47:33 by Rajendra Kumar Dangwal <dangwalrajendra888 at gmail.com>
Latest at 2024-11-07 10:16:54 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (pg_publication_doc_v1.diff) at 2024-11-07 09:15:17 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com>
    Attachment (pg_publication_doc_v1.diff) at 2024-11-07 09:15:17 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (v50-0002-Tap-tests-for-generated-columns.patch) at 2024-11-06 10:48:29 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v49_0001_amit.diff.txt) at 2024-11-06 05:22:58 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v49-0001-Enable-support-for-publish_generated_columns-par.patch) at 2024-11-05 14:39:56 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v48_0001_amit.patch.txt) at 2024-11-05 10:55:35 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v48-0002-DOCS-Generated-Column-Replication.patch) at 2024-11-05 05:47:02 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v47-0002-DOCS-Generated-Column-Replication.patch) at 2024-11-04 14:58:53 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Update-Documentation-for-Generated-Columns-in-Log.patch) at 2024-11-03 13:27:58 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_GENCOLS_V10001.txt) at 2024-11-01 01:40:23 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Update-documentation-for-generated-columns-in-logica.patch) at 2024-10-31 02:13:28 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Enable-support-for-publish_generated_columns-opti.patch) at 2024-10-30 16:16:06 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v46-0001-Replicate-generated-columns-when-specified-in-th.patch) at 2024-10-29 15:20:15 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v45-0001-Allow-logical-replication-to-publish-generated-c.patch) at 2024-10-29 09:40:44 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v44-0001-Support-logical-replication-of-generated-columns.patch) at 2024-10-28 13:07:26 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v43_0001_amit.1.patch.txt) at 2024-10-28 05:33:55 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (refactor_dump.txt) at 2024-10-28 03:17:23 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v43-0001-Support-logical-replication-of-generated-columns.patch) at 2024-10-25 14:04:07 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Enable-support-for-publish_generated_columns-opt.patch) at 2024-10-24 15:17:37 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v41-0003-Tap-tests-for-generated-columns.patch) at 2024-10-24 06:45:46 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20241022_GENCOLS_V400003.txt) at 2024-10-22 07:28:18 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20241022_GENCOLS_V400001.txt) at 2024-10-22 01:02:58 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v40-0003-Tap-tests-for-generated-columns.patch) at 2024-10-18 12:12:08 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v39-0002-DOCS-Generated-Column-Replication.patch) at 2024-10-16 17:54:56 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v38-0002-DOCS-Generated-Column-Replication.patch) at 2024-10-10 00:45:00 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_GENCOLS_v370001.txt) at 2024-10-09 05:43:11 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v37-0003-Tap-tests-for-generated-columns.patch) at 2024-10-08 06:07:16 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_GENCOLS_v360001.txt) at 2024-10-04 04:05:52 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v36-0002-Support-replication-of-generated-column-during-i.patch) at 2024-10-03 11:00:14 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v35-0002-Support-replication-of-generated-column-during-i.patch) at 2024-09-30 08:33:39 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240930_V340001.txt) at 2024-09-30 06:17:05 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v34-0003-DOCS-Generated-Column-Replication.patch) at 2024-09-27 14:31:28 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v33-0003-DOCS-Generated-Column-Replication.patch) at 2024-09-26 06:14:55 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_v320002.txt) at 2024-09-24 01:37:49 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_v320001.txt) at 2024-09-23 23:46:30 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v32-0002-Support-replication-of-generated-column-during-i.patch) at 2024-09-20 11:45:27 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_GENCOLS_V310002.txt) at 2024-09-18 03:28:08 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_GENCOLS_V310001.txt) at 2024-09-17 09:42:22 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_GENCOLS_v310001_DOCS.txt) at 2024-09-17 07:43:36 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Enable-support-for-publish_generated_columns-opt.patch) at 2024-09-13 11:34:06 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v30-0002-Tap-tests-for-generated-columns.patch) at 2024-09-09 09:38:19 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-08-23 10:56:24 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v28-0002-Tap-tests-for-include-generated-columns.patch) at 2024-08-22 04:52:03 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240819_GENCOLS_V270001.txt) at 2024-08-19 05:31:13 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-08-16 11:10:33 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-08-16 04:34:46 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-08-08 05:23:07 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240807_gencols_v240001.txt) at 2024-08-07 08:00:37 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-08-07 05:26:16 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240805_gencols_230001.txt) at 2024-08-05 02:40:01 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-08-02 04:26:59 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240801_gencols_v220001.txt) at 2024-08-01 08:32:21 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v22-0003-Fix-behaviour-for-Virtual-Generated-columns.patch) at 2024-07-31 08:42:01 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-07-26 12:23:46 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-07-19 06:01:01 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240718_GENCOLS_v190002.txt) at 2024-07-18 08:24:39 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240718_GENCOLS_V190001.txt) at 2024-07-18 05:17:16 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v19-0002-Support-replication-of-generated-column-during-i.patch) at 2024-07-16 11:19:42 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v18-0002-Support-replication-of-generated-column-during-i.patch) at 2024-07-16 08:57:44 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240715_GENCOLS_V170003.txt) at 2024-07-15 02:38:20 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_GENCOLS_V170001.txt) at 2024-07-12 06:43:15 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v17-0002-Support-replication-of-generated-column-during-i.patch) at 2024-07-11 06:12:58 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240709_V160002.txt) at 2024-07-09 01:44:10 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-07-08 12:03:14 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240705_GENCOLS_V150001.txt) at 2024-07-08 05:22:54 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v15-0002-Support-replication-of-generated-column-during-i.patch) at 2024-07-05 12:01:11 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240705_GENCOLS_V140002.txt) at 2024-07-05 08:17:22 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v14-0002-Support-replication-of-generated-column-during-i.patch) at 2024-07-04 10:28:35 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240702_v130001.txt) at 2024-07-02 04:23:06 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Enable-support-for-include_generated_columns-opt.patch) at 2024-07-01 10:38:03 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240627_GENCOLS_V110001.txt) at 2024-06-27 09:10:59 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v12-0002-Support-replication-of-generated-column-during-i.patch) at 2024-06-27 05:29:01 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Support-replication-of-generated-column-during-i.patch) at 2024-06-26 12:12:24 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240626_V100003.txt) at 2024-06-26 02:36:07 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240625_V100002.txt) at 2024-06-25 06:25:50 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Support-replication-of-generated-column-during-i.patch) at 2024-06-24 12:56:03 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240624_v90001.txt) at 2024-06-24 02:51:26 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Currently-generated-column-values-are-not-replica.patch) at 2024-06-22 18:06:00 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240621_v90003.txt) at 2024-06-21 07:20:33 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240621_v90002.txt) at 2024-06-21 03:33:16 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Currently-generated-column-values-are-not-replica.patch) at 2024-06-20 13:00:19 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240620_v80001.txt) at 2024-06-20 03:33:14 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Currently-generated-column-values-are-not-replica.patch) at 2024-06-19 11:22:20 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240618_commit_msg.txt.txt) at 2024-06-18 05:26:45 from Peter Smith <smithpb2250 at gmail.com> (Patch: No)
    Attachment (PS_NITPICKS_20240617_v70001.txt) at 2024-06-17 08:27:30 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Support-replication-of-generated-column-during-in.patch) at 2024-06-15 10:41:23 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Enable-support-for-include_generated_columns-opti.patch) at 2024-06-14 10:22:03 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (PS_20240604_v50003_nitpicks.txt) at 2024-06-04 09:30:49 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Enable-support-for-include_generated_columns-opti.patch) at 2024-06-03 11:52:35 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Enable-support-for-include_generated_columns-opti.patch) at 2024-06-03 07:33:00 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Support-generated-column-capturing-generated-colu.patch) at 2024-05-23 03:49:03 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Support-generated-column-capturing-generated-colu.patch) at 2024-05-20 06:46:17 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Support-capturing-generated-column-data-using-pgo.patch) at 2024-05-08 07:13:45 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
History
When Who What
2024-10-08 03:23:39 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-10-08 03:23:36 Michael Paquier (michael-kun) New status: Waiting on Author
2024-09-27 00:39:17 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
2024-09-26 06:56:08 Peter Smith (smithpb2250) Changed authors to Peter Smith (smithpb2250), Shubham Khanna (skhanna), Shlok Kyal (shlokkyal)
2024-08-01 06:23:09 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-06-25 04:42:38 Hayato Kuroda (ha-kun) Changed reviewers to Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb)
2024-06-25 04:42:38 Hayato Kuroda (ha-kun) Changed targetversion to 18
2024-06-25 04:01:38 Shlok Kyal (shlokkyal) Changed authors to Shubham Khanna (skhanna), Shlok Kyal (shlokkyal)
2024-06-24 01:20:41 Hayato Kuroda (ha-kun) Added ha-kun as reviewer
2024-06-23 04:28:01 Hayato Kuroda (ha-kun) Changed authors to Shubham Khanna (skhanna)
2024-06-23 04:26:36 Hayato Kuroda (ha-kun) Attached mail thread B80D17B2-2C8E-4C7D-87F2-E5B4BE3C069E@gmail.com
2024-06-23 04:26:36 Hayato Kuroda (ha-kun) Created patch record
Edit