Support EXCEPT for TABLES IN SCHEMA publications

9 patchsets tracked - current t139321_173

v173t139321_173posted Aug 19, 10:17successwon't retrystale 44dpg 20

base9f4bd91a1 Sep 10, 08:30 on master

applyapplied Sep 10, 09:32

rebaselast tried Oct 09, 17:09 on e01fc6315

Applying: Support EXCEPT clause for schema-level publications
Using index info to reconstruct a base tree...
M	src/backend/catalog/pg_publication.c
M	src/backend/commands/publicationcmds.c
M	src/backend/commands/tablecmds.c
M	src/backend/parser/gram.y
M	src/backend/replication/pgoutput/pgoutput.c
M	src/backend/utils/cache/relcache.c
M	src/bin/psql/describe.c
M	src/bin/psql/tab-complete.in.c
M	src/include/catalog/pg_publication.h
M	src/include/nodes/parsenodes.h
M	src/test/regress/expected/publication.out
M	src/test/regress/sql/publication.sql
M	src/test/subscription/t/037_except.pl
Falling back to patching base and 3-way merge...
Auto-merging src/test/subscription/t/037_except.pl
CONFLICT (content): Merge conflict in src/test/subscription/t/037_except.pl
Auto-merging src/test/regress/sql/publication.sql
Auto-merging src/test/regress/expected/publication.out
CONFLICT (content): Merge conflict in src/test/regress/expected/publication.out
Auto-merging src/include/nodes/parsenodes.h
Auto-merging src/include/catalog/pg_publication.h
Auto-merging src/bin/psql/tab-complete.in.c
Auto-merging src/bin/psql/describe.c
Auto-merging src/backend/utils/cache/relcache.c
CONFLICT (content): Merge conflict in src/backend/utils/cache/relcache.c
Auto-merging src/backend/replication/pgoutput/pgoutput.c
Auto-merging src/backend/parser/gram.y
Auto-merging src/backend/commands/tablecmds.c
Auto-merging src/backend/commands/publicationcmds.c
Auto-merging src/backend/catalog/pg_publication.c
CONFLICT (content): Merge conflict in src/backend/catalog/pg_publication.c
Patch failed at 0001 Support EXCEPT clause for schema-level publications

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: src/test/subscription/t/037_except.pl, src/test/regress/expected/publication.out, src/backend/utils/cache/relcache.c, src/backend/catalog/pg_publication.c

pushSep 10, 09:33 -> 92d592f0e branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1022 / 1022	2m 55s / 5m 11s	`docker run ... :t139321`	Sep 10, 09:48
run 34461253067 executed 1022 - ccache 98 hit / 6523 miss - head 92d592f0e - digest sha256:9be30aece5e94b... - run 34461253067
success	1	20	1020 / 1020	3m 02s / 5m 22s	`docker run ... @sha256:35578ca...`	Sep 09, 09:46
run 34335119590 executed 1020 - ccache 98 hit / 6523 miss - head 90494d2fa - digest sha256:35578ca9617706... - run 34335119590
success	1	20	1020 / 1020	2m 55s / 5m 29s	`docker run ... @sha256:1e66922...`	Sep 08, 09:45
run 34210244879 executed 1020 - ccache 98 hit / 6523 miss - head 690d608c4 - digest sha256:1e669228bc7122... - run 34210244879
success	1	20	1024 / 1024	2m 54s / 5m 19s	`docker run ... @sha256:9e026be...`	Sep 07, 09:43
run 34106018203 executed 1024 - ccache 98 hit / 6527 miss - head 27e2d5a13 - digest sha256:9e026beec92c51... - run 34106018203
success	1	20	1024 / 1024	1m 48s / 4m 23s	`docker run ... @sha256:55746d7...`	Sep 05, 11:33
run 33963082476 executed 1024 - ccache 98 hit / 6527 miss - head bca901b5d - digest sha256:55746d73c5049c... - run 33963082476
success	1	20	1024 / 1024	2m 59s / 5m 36s	`docker run ... @sha256:fdfa730...`	Sep 04, 11:33
run 33867376402 executed 1024 - ccache 98 hit / 6527 miss - head fc026b8ba - digest sha256:fdfa730351f196... - run 33867376402
success	1	20	1023 / 1023	2m 52s / 5m 31s	`docker run ... @sha256:80005a5...`	Sep 03, 11:32
run 33748871396 executed 1023 - ccache 98 hit / 6526 miss - head 1b4fa05fd - digest sha256:80005a5bae0dd8... - run 33748871396
success	1	20	1022 / 1022	2m 54s / 5m 35s	`docker run ... @sha256:d29cd27...`	Sep 02, 11:29
run 33623419275 executed 1022 - ccache 98 hit / 6526 miss - head 0385dd78f - digest sha256:d29cd27ade9422... - run 33623419275
success	1	20	1022 / 1022	2m 53s / 4m 57s	`docker run ... @sha256:37895b3...`	Sep 01, 11:27
run 33501153483 executed 1022 - ccache 98 hit / 6526 miss - head 08e5a31ce - digest sha256:37895b39d03f99... - run 33501153483
success	1	20	1022 / 1022	2m 56s / 5m 19s	`docker run ... @sha256:9b9c905...`	Aug 31, 11:09
run 33384796212 executed 1022 - ccache 98 hit / 6526 miss - head 14e69c636 - digest sha256:9b9c905687cb1e... - run 33384796212
success	1	20	1021 / 1021	2m 21s / 4m 15s	`docker run ... @sha256:0220316...`	Aug 30, 11:06
run 33307699740 executed 1021 - ccache 98 hit / 6525 miss - head 5e1afce53 - digest sha256:02203162bf59ca... - run 33307699740
success	1	20	1021 / 1021	2m 58s / 5m 43s	`docker run ... @sha256:63e1d9a...`	Aug 29, 11:07
run 33248943791 executed 1021 - ccache 98 hit / 6525 miss - head fbfcdb039 - digest sha256:63e1d9ac37d1e3... - run 33248943791
success	1	20	1021 / 1021	1m 51s / 4m 11s	`docker run ... @sha256:dcdf8c6...`	Aug 28, 11:02
run 33165090638 executed 1021 - ccache 98 hit / 6525 miss - head 23457211b - digest sha256:dcdf8c6a998124... - run 33165090638
success	1	20	1021 / 1021	2m 48s / 5m 11s	`docker run ... @sha256:607458d...`	Aug 27, 11:03
run 33064886127 executed 1021 - ccache 98 hit / 6525 miss - head d2ef09dfd - digest sha256:607458d5dfec41... - run 33064886127
success	1	20	1024 / 1024	2m 56s / 5m 41s	`docker run ... @sha256:48a56a0...`	Aug 26, 11:01
run 32959870460 executed 1024 - ccache 98 hit / 6525 miss - head 68441f0af - digest sha256:48a56a0540b92f... - run 32959870460
success	1	20	1023 / 1023	2m 58s / 5m 40s	`docker run ... @sha256:f46760d...`	Aug 24, 10:36
run 32716600688 executed 1023 - ccache 98 hit / 6525 miss - head 444690bd9 - digest sha256:f46760d4465888... - run 32716600688
success	1	20	1023 / 1023	2m 58s / 5m 21s	`docker run ... @sha256:3ccf4d7...`	Aug 23, 10:35
run 32633611102 executed 1023 - ccache 98 hit / 6525 miss - head b9c925070 - digest sha256:3ccf4d7ff5e2d8... - run 32633611102
success	1	20	1023 / 1023	2m 25s / 4m 09s	`docker run ... @sha256:a1a0d02...`	Aug 22, 10:32
run 32567424365 executed 1023 - ccache 98 hit / 6525 miss - head 71c6c7e25 - digest sha256:a1a0d02d2057e7... - run 32567424365
success	1	20	1023 / 1023	2m 10s / 4m 20s	`docker run ... @sha256:e91e9a4...`	Aug 21, 10:30
run 32472247877 executed 1023 - ccache 98 hit / 6525 miss - head 56c411e85 - digest sha256:e91e9a4f082748... - run 32472247877
success	1	20	1023 / 1023	2m 10s / 4m 53s	`docker run ... @sha256:0e472bd...`	Aug 20, 10:31
run 32358487761 executed 1023 - ccache 98 hit / 6525 miss - head f923fa337 - digest sha256:0e472bda4f58ba... - run 32358487761
success	1	20	1023 / 1023	2m 55s / 5m 13s	`docker run ... @sha256:a4047d5...`	Aug 19, 10:31
run 32242170154 executed 1023 - ccache 98 hit / 6525 miss - head f26a32e69 - digest sha256:a4047d59531af2... - run 32242170154

v168t139321_168posted Aug 18, 13:27supersededstale 2mopg 20apply failed

v166t139321_166posted Aug 18, 04:54successsupersededstale 2mopg 20

basebe97b984f Aug 19, 03:37 on master

applyapplied Aug 19, 04:59

rebaselast tried Aug 19, 04:59 on be97b984f

pushAug 19, 04:59 -> 45ac5e2bd branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1023 / 1023	2m 47s / 4m 38s	`docker run ... @sha256:b50f12b...`	Aug 19, 05:15
run 32217760987 executed 1023 - ccache 98 hit / 6525 miss - head 45ac5e2bd - digest sha256:b50f12be5dcea3... - run 32217760987
success	1	20	1020 / 1020	2m 55s / 5m 19s	`docker run ... @sha256:3abe08d...`	Aug 18, 05:13
run 32100979584 executed 1020 - ccache 98 hit / 6524 miss - head 448860ce1 - digest sha256:3abe08d81905c7... - run 32100979584

v160t139321_160posted Aug 14, 14:15successsupersededstale 2mopg 20

base51c43a5db Aug 17, 07:15 on master

applyapplied Aug 17, 14:18

rebaselast tried Aug 17, 14:18 on 51c43a5db

pushAug 17, 14:18 -> 644795832 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1019 / 1019	2m 56s / 5m 17s	`docker run ... @sha256:4f2ff9a...`	Aug 17, 14:29
run 32038574938 executed 1019 - ccache 98 hit / 6524 miss - head 644795832 - digest sha256:4f2ff9ae0e1c49... - run 32038574938
success	1	20	1019 / 1019	2m 15s / 4m 03s	`docker run ... @sha256:e428095...`	Aug 16, 14:27
run 31952312354 executed 1019 - ccache 98 hit / 6524 miss - head 12109b516 - digest sha256:e428095ea6c7eb... - run 31952312354
success	1	20	1019 / 1019	2m 48s / 5m 04s	`docker run ... @sha256:049d953...`	Aug 15, 14:27
run 31889504358 executed 1019 - ccache 98 hit / 6524 miss - head e8065d312 - digest sha256:049d953ab38120... - run 31889504358
success	1	20	1019 / 1019	2m 15s / 4m 35s	`docker run ... @sha256:9555dab...`	Aug 14, 14:26
run 31808740938 executed 1019 - ccache 165 hit / 6457 miss - head 3379b16ed - digest sha256:9555dabf99d6f1... - run 31808740938

v149t139321_149posted Aug 11, 08:57successsupersededstale 2mopg 20

base9a08585e8 Aug 14, 08:40 on master

applyapplied Aug 14, 09:03

rebaselast tried Aug 14, 09:03 on 9a08585e8

pushAug 14, 09:03 -> bdcbcae95 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1019 / 1019	2m 25s / 4m 19s	`docker run ... @sha256:04f9fc4...`	Aug 14, 09:15
run 31786463975 executed 1019 - ccache 165 hit / 6457 miss - head bdcbcae95 - digest sha256:04f9fc4961eb30... - run 31786463975
success	1	20	1019 / 1019	2m 57s / 5m 24s	`docker run ... @sha256:1c63317...`	Aug 13, 09:19
run 31684785279 executed 1019 - ccache 165 hit / 6457 miss - head 0807688e1 - digest sha256:1c633178fb5fcb... - run 31684785279
success	1	20	1019 / 1019	2m 48s / 5m 05s	`docker run ... @sha256:9c99a6d...`	Aug 12, 09:17
run 31581008881 executed 1019 - ccache 165 hit / 6457 miss - head 219b5ca09 - digest sha256:9c99a6dc754d56... - run 31581008881
success	1	20	1019 / 1019	3m 00s / 5m 35s	`docker run ... @sha256:3baaa15...`	Aug 11, 09:17
run 31475793193 executed 1019 - ccache 165 hit / 6453 miss - head 884f0e337 - digest sha256:3baaa15784ffe0... - run 31475793193

v140t139321_140posted Aug 04, 08:41successsupersededstale 3mopg 20

baseb59783502 Aug 07, 15:09 on master

applyapplied Aug 08, 08:45

rebaselast tried Aug 11, 08:06 on 1d1d7b0e9

Applying: Support EXCEPT clause for schema-level publications
Using index info to reconstruct a base tree...
M	src/backend/catalog/pg_publication.c
M	src/backend/commands/tablecmds.c
M	src/backend/replication/pgoutput/pgoutput.c
M	src/bin/psql/describe.c
M	src/bin/psql/tab-complete.in.c
M	src/include/nodes/parsenodes.h
M	src/test/regress/expected/publication.out
Falling back to patching base and 3-way merge...
Auto-merging src/test/regress/expected/publication.out
Auto-merging src/include/nodes/parsenodes.h
Auto-merging src/bin/psql/tab-complete.in.c
Auto-merging src/bin/psql/describe.c
Auto-merging src/backend/replication/pgoutput/pgoutput.c
Auto-merging src/backend/commands/tablecmds.c
Auto-merging src/backend/catalog/pg_publication.c
CONFLICT (content): Merge conflict in src/backend/catalog/pg_publication.c
Patch failed at 0001 Support EXCEPT clause for schema-level publications

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: src/backend/catalog/pg_publication.c

pushAug 08, 08:45 -> c42d939fc branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1019 / 1019	2m 58s / 5m 24s	`docker run ... @sha256:fc64f32...`	Aug 08, 08:56
run 31249092917 executed 1019 - ccache 166 hit / 6452 miss - head c42d939fc - digest sha256:fc64f3227114f6... - run 31249092917
success	1	20	1018 / 1018	2m 11s / 4m 46s	`docker run ... @sha256:3bbd9a5...`	Aug 07, 08:54
run 31163002973 executed 1018 - ccache 166 hit / 6452 miss - head 041afc39f - digest sha256:3bbd9a574f1f97... - run 31163002973
success	1	20	1018 / 1018	2m 56s / 5m 18s	`docker run ... @sha256:a816adc...`	Aug 06, 08:55
run 31086147582 executed 1018 - ccache 166 hit / 6452 miss - head 252cdae09 - digest sha256:a816adc8ef796f... - run 31086147582
success	1	20	1018 / 1018	2m 52s / 5m 24s	`docker run ... @sha256:50eb947...`	Aug 05, 08:54
run 30990221589 executed 1018 - ccache 166 hit / 6452 miss - head 77551e435 - digest sha256:50eb94721d3325... - run 30990221589
success	1	20	1018 / 1018	2m 52s / 5m 25s	`docker run ... @sha256:97d6676...`	Aug 04, 08:54
run 30893175214 executed 1018 - ccache 166 hit / 6452 miss - head 79871fa7d - digest sha256:97d6676746b477... - run 30893175214

v133t139321_133posted Jul 30, 06:03successsupersededstale 3mopg 20

baseb4dfae2ff Aug 04, 05:59 on master

applyapplied Aug 04, 06:08

rebaselast tried Aug 04, 06:08 on b4dfae2ff

pushAug 04, 06:08 -> b58568d33 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1018 / 1018	2m 53s / 5m 34s	`docker run ... @sha256:0c4198e...`	Aug 04, 06:19
run 30882993718 executed 1018 - ccache 166 hit / 6452 miss - head b58568d33 - digest sha256:0c4198ea4237d8... - run 30882993718
success	1	20	1017 / 1017	2m 45s / 4m 52s	`docker run ... @sha256:e6b30bc...`	Aug 03, 06:18
run 30789172103 executed 1017 - ccache 166 hit / 6452 miss - head 69539c54f - digest sha256:e6b30bcb736013... - run 30789172103
success	1	20	1017 / 1017	1m 53s / 3m 57s	`docker run ... @sha256:ac7f1f3...`	Aug 02, 06:16
run 30735345579 executed 1017 - ccache 166 hit / 6452 miss - head 4298f51d5 - digest sha256:ac7f1f36bb3258... - run 30735345579
success	1	20	1017 / 1017	2m 55s / 5m 27s	`docker run ... @sha256:27a9aa1...`	Aug 01, 06:17
run 30687105801 executed 1017 - ccache 166 hit / 6452 miss - head 977d09bf5 - digest sha256:27a9aa1afc8fcd... - run 30687105801
success	1	20	1016 / 1016	2m 49s / 5m 25s	`docker run ... @sha256:7598367...`	Jul 31, 06:16
run 30608610667 executed 1016 - ccache 166 hit / 6452 miss - head 0acce4561 - digest sha256:759836771ebd09... - run 30608610667
success	1	20	1016 / 1016	2m 51s / 5m 24s	`docker run ... @sha256:7083614...`	Jul 30, 06:14
run 30518426507 executed 1016 - ccache 166 hit / 6452 miss - head 4b5619028 - digest sha256:7083614b231db0... - run 30518426507

v125t139321_125posted Jul 23, 11:55successsupersededstale 3mopg 20

base1a8c17222 Jul 23, 05:16 - 93 days / 888 commits behind master (from history)

applyapplied Jul 28, 21:55

rebaselast tried Jul 29, 21:57 on b43e8f4b3

Applying: Documentation Patch
Using index info to reconstruct a base tree...
M	doc/src/sgml/ref/alter_publication.sgml
M	doc/src/sgml/ref/create_publication.sgml
Falling back to patching base and 3-way merge...
Auto-merging doc/src/sgml/ref/create_publication.sgml
Auto-merging doc/src/sgml/ref/alter_publication.sgml
CONFLICT (content): Merge conflict in doc/src/sgml/ref/alter_publication.sgml
Patch failed at 0001 Documentation Patch

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: doc/src/sgml/ref/alter_publication.sgml

pushJul 28, 21:55 -> 1a4033bd1 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1010 / 1010	2m 38s / 4m 23s	`docker run ... @sha256:77c6b1c...`	Jul 28, 22:07
run 30402622282 executed 1010 - ccache 166 hit / 6452 miss - head 1a4033bd1 - digest sha256:77c6b1c103c797... - run 30402622282

v52t139321_52posted Jun 05, 11:41successsupersededstale 5mopg 19

base298bdd379 Jun 03, 10:01 - 143 days / 1326 commits behind master (from history)

applyapplied Jul 28, 14:31

rebaselast tried Jul 28, 14:31 on 8a045f760

Applying: Add EXCEPT support to ALTER PUBLICATION ADD TABLES IN SCHEMA
Using index info to reconstruct a base tree...
M	doc/src/sgml/ref/alter_publication.sgml
M	src/backend/catalog/pg_publication.c
M	src/bin/pg_dump/pg_dump.c
M	src/bin/pg_dump/t/002_pg_dump.pl
M	src/bin/psql/tab-complete.in.c
M	src/test/regress/expected/publication.out
M	src/test/regress/sql/publication.sql
M	src/test/subscription/t/037_except.pl
Falling back to patching base and 3-way merge...
Auto-merging src/test/subscription/t/037_except.pl
Auto-merging src/test/regress/sql/publication.sql
Auto-merging src/test/regress/expected/publication.out
Auto-merging src/bin/psql/tab-complete.in.c
Auto-merging src/bin/pg_dump/t/002_pg_dump.pl
Auto-merging src/bin/pg_dump/pg_dump.c
Auto-merging src/backend/catalog/pg_publication.c
Auto-merging doc/src/sgml/ref/alter_publication.sgml
CONFLICT (content): Merge conflict in doc/src/sgml/ref/alter_publication.sgml
Patch failed at 0001 Add EXCEPT support to ALTER PUBLICATION ADD TABLES IN SCHEMA

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: doc/src/sgml/ref/alter_publication.sgml

pushJul 28, 14:32 -> 6bcf2579f branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	19	1005 / 1005	2m 51s / 5m 23s	`docker run ... @sha256:444d4ca...`	Jul 28, 14:51
run 30368839194 executed 1005 - ccache 145 hit / 6474 miss - head 6bcf2579f - digest sha256:444d4cada289cb... - run 30368839194