Data is copied twice when specifying both child and parent table in publication

Edit
ID 3623
Title Data is copied twice when specifying both child and parent table in publication
Topic Bug Fixes
Created 2022-04-21 04:03:49
Last modified 2023-03-30 08:09:19 (1 year, 6 months ago)
Latest email 2023-03-31 23:05:37 (1 year, 6 months ago)
Status
2023-03: Committed
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
Target version
Authors wei wang (wangwei), Yu Shi (shiy.fnst)
Reviewers Hou Zhijie (houzj), Takamichi Osumi (tatatappp), Amit Kapila (amitkapila), vigneshwaran C (vignesh.postgres)Become reviewer
Committer Amit Kapila (amitkapila)
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/3623
git checkout commitfest/cf/3623
Emails
Data is copied twice when specifying both child and parent table in publication
First at 2021-10-15 11:22:50 by "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com>
Latest at 2023-03-31 23:05:37 by Jacob Champion <jchampion at timescale.com>
Latest attachment (repro.sql) at 2023-03-30 18:15:46 from Jacob Champion <jchampion at timescale.com>
    Attachment (repro.sql) at 2023-03-30 18:15:46 from Jacob Champion <jchampion at timescale.com> (Patch: No)
    Attachment (v25-0001-Avoid-syncing-data-twice-for-the-publish_via_par.patch) at 2023-03-28 10:09:27 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v25-0001-Avoid-syncing-data-twice-for-the-publish_via_par.patch) at 2023-03-28 09:59:49 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v24-0001-Avoid-syncing-data-twice-for-the-publish_via_par.patch) at 2023-03-27 05:18:07 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v23-0001-Avoid-syncing-data-twice-for-the-publish_via_par.patch) at 2023-03-25 10:51:22 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2023-03-24 09:06:45 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v21-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2023-03-23 09:11:29 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v20-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2023-03-22 10:07:49 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v19-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2023-03-21 07:40:00 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (change_comments_1.patch.txt) at 2023-03-20 10:14:49 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (HEAD_v18-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2023-03-20 00:53:56 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD-v17-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2023-03-17 06:28:00 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v16-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2023-02-08 03:51:08 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v15-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2022-11-16 08:58:31 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v14-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2022-11-11 05:43:10 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v13-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2022-10-17 05:49:23 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v12-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2022-09-28 08:35:33 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v11-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2022-09-26 04:44:00 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v10-0001-Fix-data-replicated-twice-when-specifying-publis.patch) at 2022-09-20 06:17:48 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v9-0001-Fix-data-replicated-twice-when-specifying-publish.patch) at 2022-08-30 07:43:06 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v8-0001-Fix-data-replicated-twice-when-specifying-publish.patch) at 2022-08-05 09:06:49 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v7-0001-Fix-data-replicated-twice-when-specifying-publish.patch) at 2022-07-21 10:07:36 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v6-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-07-01 09:46:43 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v5-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-05-18 08:51:26 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v5-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-05-18 08:37:56 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v4-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-05-13 09:41:42 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v3-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-05-13 02:02:25 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v2-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-05-09 01:51:09 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD_v1-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-04-24 06:16:04 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v3-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-04-21 03:05:13 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-04-19 08:53:09 from "shiy.fnst at fujitsu.com" <shiy.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v1-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch) at 2022-04-07 03:08:14 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD-0001-Fix-double-publish-of-child-table-s-data.patch) at 2021-12-03 05:54:21 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (HEAD-0001-Fix-double-publish-of-child-table-s-data.patch) at 2021-12-02 08:54:18 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v7-0001-Fix-double-publish-of-child-table-s-data.patch) at 2021-12-01 11:15:00 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Fix-double-publish-of-child-table-s-data.patch) at 2021-11-29 08:51:35 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v5-0002-fix-duplicate-table-in-pg_publication_tables.patch) at 2021-11-11 06:52:40 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v4-0001-fix-data-double-published.patch) at 2021-10-28 07:35:07 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v3-0001-fix-double-publish.patch) at 2021-10-18 08:46:13 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-fix-double-publish.patch) at 2021-10-16 06:30:47 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-fix-double-publish.patch) at 2021-10-15 11:22:50 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
History
When Who What
2023-03-30 08:09:19 wei wang (wangwei) Closed in commitfest 2023-03 with status: Committed
2023-03-30 08:09:19 wei wang (wangwei) Changed committer to amitkapila
2023-01-31 01:03:35 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-03 02:56:20 vigneshwaran C (vignesh.postgres) Added vignesh.postgres as reviewer
2022-12-13 07:22:07 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-11-11 05:47:21 wei wang (wangwei) New status: Needs review
2022-11-03 23:34:11 Ian Barwick (barwick) New status: Waiting on Author
2022-10-18 02:31:15 wei wang (wangwei) New status: Needs review
2022-10-12 05:11:27 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-07 12:17:32 Ibrar Ahmed (ibrar) New status: Waiting on Author
2022-09-02 22:29:16 Justin Pryzby (justinpryzby) New status: Needs review
2022-08-01 21:06:45 Jacob Champion (jchampion) New status: Waiting on Author
2022-08-01 21:06:12 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-18 22:47:52 Jacob Champion (jchampion) Changed reviewers to Amit Kapila (amitkapila), Takamichi Osumi (tatatappp), Hou Zhijie (houzj)
2022-07-15 20:35:16 Jacob Champion (jchampion) Changed reviewers to
2022-05-18 06:40:51 wei wang (wangwei) Changed reviewers to Amit Kapila (amitkapila), Takamichi Osumi (tatatappp), Hou Zhijie (houzj)
2022-05-18 06:40:16 wei wang (wangwei) Removed wangwei from reviewers
2022-05-18 06:40:13 wei wang (wangwei) Added wangwei as reviewer
2022-04-21 04:05:18 wei wang (wangwei) Changed reviewers to Hou Zhijie (houzj)
2022-04-21 04:05:18 wei wang (wangwei) Changed authors to wei wang (wangwei), yu Shi (shiy.fnst)
2022-04-21 04:03:50 wei wang (wangwei) Attached mail thread OS0PR01MB57167F45D481F78CDC5986F794B99@OS0PR01MB5716.jpnprd01.prod.outlook.com
2022-04-21 04:03:49 wei wang (wangwei) Created patch record
Edit