Horton

Fix miscellaneous issues in EXCEPT publication clause.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: 6b0550c45d132c7a75acf98cb76f8a43bf5e94df
Author: Amit Kapila <akapila@postgresql.org>
Date: 2026-04-01T03:43:43Z
Releases: 19 (unreleased) 
Fix miscellaneous issues in EXCEPT publication clause.

Improve documentation regarding multiple publications and partition
hierarchies. Refine error reporting for excluded relations. Consolidate
docs by using table_object instead of expanded table syntax in publication
commands. Also includes minor test cleanup and naming fixes.

Reported-by: Peter Smith <smithpb2250@gmail.com>
Author: vignesh C <vignesh21@gmail.com>
Reviewed-by: Peter Smith <smithpb2250@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CALDaNm1CiBYcteE_jjPA4BPHfX30dg9eTTTkJgkjY5tgE7t=bQ@mail.gmail.com
Discussion: https://postgr.es/m/CALDaNm3=JrucjhiiwsYQw5-PGtBHFONa6F7hhWCXMsGvh=tamA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/ref/alter_publication.sgml modified +2 −2
doc/src/sgml/ref/create_publication.sgml modified +3 −3
src/backend/catalog/pg_publication.c modified +1 −1
src/test/regress/expected/publication.out modified +1 −1
src/test/subscription/t/037_except.pl modified +12 −12

Discussion