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, 7 months ago)

Latest email 2023-03-31 23:05:37 (1 year, 7 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