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

Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com>

View thread View on postgr.es

From: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>

To: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>

Cc: Greg Nancarrow <gregn4422@gmail.com>

Date: 2021-10-16T06:30:47Z

Lists: pgsql-hackers

Attachments

v2-0001-fix-double-publish.patch (application/octet-stream) patch v2-0001

On Friday, October 15, 2021 7:23 PM houzj.fnst@fujitsu.com wrote:
> Attach a patch to fix it.
Attach a new version patch which refactor the fix code in a cleaner way.

Best regards,
Hou zj

Commits

Avoid syncing data twice for the 'publish_via_partition_root' option.
- 062a84442424 16.0 landed
Fix partition table's REPLICA IDENTITY checking on the subscriber.
- 52d5ea9adb01 14.5 cited
Prohibit combining publications with different column lists.
- fd0b9dcebda7 15.0 cited
Fix double publish of child table's data.
- 3f06c00cf6dc 13.6 landed
- 614b77d65a38 14.2 landed
- 5e97905a2c76 15.0 landed
Support adding partitioned tables to publication
- 17b9e7f9fe23 13.0 cited