Column filtering in logical replication

Edit

ID 3230

Title Column filtering in logical replication

Topic Replication & Recovery

Created 2021-06-30 19:37:37

Last modified 2022-03-26 18:21:44 (2 years, 7 months ago)

Latest email 2022-03-30 12:01:38 (2 years, 7 months ago)

Status

2022-03: Committed

2022-01: Moved to next CF

2021-11: Moved to next CF

2021-09: Moved to next CF

2021-07: Moved to next CF

Target version 15

Authors Álvaro Herrera (alvherre), Rahila Syed (rahila.syed), Tomas Vondra (fuzzycz)

Reviewers Álvaro Herrera (alvherre), Peter Eisentraut (petere), vigneshwaran C (vignesh.postgres)Become reviewer

Committer Tomas Vondra (fuzzycz)

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/3230
git checkout commitfest/cf/3230

Emails

Column Filtering in Logical Replication: First at 2021-06-30 19:36:11 by Rahila Syed <rahilasyed90 at gmail.com>
Latest at 2022-03-30 12:01:38 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest attachment (prattrs_column_fix_v1.diff) at 2022-03-26 04:09:17 from "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi.shinoda at hpe.com>
    Attachment (prattrs_column_fix_v1.diff) at 2022-03-26 04:09:17 from "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (0001-Allow-specifying-column-lists-for-logical-re20220325.patch) at 2022-03-25 00:14:48 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-fixup-Allow-specifying-column-lists-for-logical-repl.patch) at 2022-03-24 16:33:56 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (debug_sub_workers_1.patch) at 2022-03-20 06:23:41 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (0001-Allow-specifying-column-lists-for-logical--20220318c.patch) at 2022-03-19 17:41:15 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Allow-specifying-column-lists-for-logical--20220318b.patch) at 2022-03-19 17:11:38 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Allow-specifying-column-lists-for-logical-r-20220318.patch) at 2022-03-18 22:26:39 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Allow-specifying-column-filters-for-logical-20220317.patch) at 2022-03-17 19:11:32 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0003-fixup-row-filter-publications-20220313.patch) at 2022-03-14 11:12:25 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-fixup-publish_as_relid-20220313.patch) at 2022-03-13 21:07:49 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v1-0001-fixup-publish_as_relid.patch) at 2022-03-12 04:30:14 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (0001-Try-to-get-column-filters-with-one-SQL.patch) at 2022-03-11 07:05:59 from "wangw.fnst at fujitsu.com" <wangw.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-fixup-publish_as_relid-20220311.patch) at 2022-03-11 01:56:41 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (row-filter-test.txt) at 2022-03-10 18:17:15 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-fixup-Allow-specifying-column-filters-for-logical-re.patch) at 2022-03-09 09:20:57 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Verify-changing-WHERE-condition-for-a-publi-20220307.patch) at 2022-03-07 15:18:04 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Verify-changing-WHERE-condition-for-a-publi-20220302.patch) at 2022-03-02 12:13:15 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Support-column-lists-for-logical-replicatio-20220216.patch) at 2022-02-15 23:33:37 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v17-0001-Support-column-lists-for-logical-replication-of-.patch) at 2022-01-11 18:52:22 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v16-0001-Support-column-lists-for-logical-replication-of-.patch) at 2022-01-10 21:38:40 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v15-0001-Support-column-lists-for-logical-replication-of-.patch) at 2022-01-03 14:31:39 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v14-0001-Avoid-use-of-DEFELEM-enum-in-AlterPublicationStm.patch) at 2021-12-30 23:32:29 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v13-0001-Small-cleanups-for-publicationcmds.c-and-pg_publ.patch) at 2021-12-30 20:21:28 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (column-filtering-12.patch) at 2021-12-30 00:15:08 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (column-filtering-11.patch) at 2021-12-28 21:04:27 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-v9.patch) at 2021-12-14 21:28:11 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (column-filtering-9.patch) at 2021-12-13 17:47:50 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (column-filtering-8.patch) at 2021-12-13 17:44:11 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Add-some-documentation.patch) at 2021-12-10 13:08:52 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (v7-0001-Add-column-filtering-to-logical-replication.patch) at 2021-12-02 14:23:58 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v6-0001-Add-column-filtering-to-logical-replication.patch) at 2021-12-01 20:29:47 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (Generic_object_type_parser_issue.patch) at 2021-09-16 05:05:21 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (Generic_object_type_parser_001_table_publication.patch) at 2021-09-15 12:19:19 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-column-filtering-to-logical-replication.patch) at 2021-09-06 17:51:52 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v4-0001-Add-column-filtering-to-logical-replication.patch) at 2021-09-01 21:21:41 from Rahila Syed <rahilasyed90 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-column-filtering-to-logical-replication.patch) at 2021-08-08 19:59:50 from Rahila Syed <rahilasyed90 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-column-filtering-to-logical-replication.patch) at 2021-07-13 14:43:44 from Rahila Syed <rahilasyed90 at gmail.com> (Patch: Yes)
    Attachment (crash.txt) at 2021-07-12 12:54:26 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (v1-0001-Add-column-filtering-to-logical-replication.patch) at 2021-07-12 09:38:23 from Rahila Syed <rahilasyed90 at gmail.com> (Patch: Yes)
    Attachment (0001-Add-column-filtering-to-logical-replication.patch) at 2021-06-30 19:36:11 from Rahila Syed <rahilasyed90 at gmail.com> (Patch: Yes)

History

When	Who	What
2022-03-26 18:21:44	Tomas Vondra (fuzzycz)	Closed in commitfest 2022-03 with status: Committed
2022-03-26 18:21:44	Tomas Vondra (fuzzycz)	Changed committer to fuzzycz
2022-03-21 12:15:41	Álvaro Herrera (alvherre)	Changed authors to Álvaro Herrera (alvherre), Rahila Syed (rahila.syed), Tomas Vondra (fuzzycz)
2022-03-17 19:23:59	Justin Pryzby (justinpryzby)	New status: Ready for Committer
2022-03-09 09:22:11	Peter Eisentraut (petere)	New status: Waiting on Author
2022-03-09 09:22:04	Peter Eisentraut (petere)	Added petere as reviewer
2022-02-02 16:38:01	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-27 21:08:37	Justin Pryzby (justinpryzby)	Changed targetversion to 15
2021-12-30 22:52:39	Álvaro Herrera (alvherre)	New status: Needs review
2021-12-10 13:09:50	Peter Eisentraut (petere)	New status: Waiting on Author
2021-12-03 09:18:58	vigneshwaran C (vignesh.postgres)	Added vignesh.postgres as reviewer
2021-12-02 11:34:03	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2021-11 with status: Moved to next CF
2021-12-01 20:37:32	Álvaro Herrera (alvherre)	New status: Needs review
2021-10-01 06:54:17	Michael Paquier (michael-kun)	New status: Waiting on Author
2021-10-01 06:54:13	Michael Paquier (michael-kun)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-10-01 06:54:09	Michael Paquier (michael-kun)	New status: Needs review
2021-09-06 18:54:38	Álvaro Herrera (alvherre)	New status: Waiting on Author
2021-09-01 21:24:11	Rahila Syed (rahila)	New status: Needs review
2021-09-01 16:29:12	Álvaro Herrera (alvherre)	Changed reviewers to Álvaro Herrera (alvherre)
2021-08-03 02:50:13	Masahiko Sawada (masahikosawada)	New status: Waiting on Author
2021-08-03 02:47:47	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:47:45	Masahiko Sawada (masahikosawada)	New status: Needs review
2021-07-19 10:21:00	Ibrar Ahmed (ibrar)	New status: Waiting on Author
2021-06-30 19:38:16	Rahila Syed (rahila)	Changed authors to Rahila Syed (rahila.syed)
2021-06-30 19:37:37	Rahila Syed (rahila)	Attached mail thread CAH2L28vddB_NFdRVpuyRBJEBWjz4BSyTB=_ektNRH8NJ1jf95g@mail.gmail.com
2021-06-30 19:37:37	Rahila Syed (rahila)	Created patch record

Edit