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

Edit

Title

Topic

Bug Fixes

Created

2022-04-21 04:03:49

Last modified

2023-03-30 08:09:19 (8 months ago)

Latest email

2023-03-31 23:05:37 (8 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

Amit Kapila (amitkapila), Takamichi Osumi (tatatappp), vigneshwaran C (vignesh.postgres), Hou Zhijie (houzj)Become reviewer

Committer

Amit Kapila (amitkapila)

Links

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