Horton

Fix changing the ownership of ALL TABLES IN SCHEMA publication.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: 1a2aaeb0db1bccd97140d479c4247127f6cb9378
Author: Amit Kapila <akapila@postgresql.org>
Date: 2021-12-08T06:01:16Z
Releases: 15.0 
Fix changing the ownership of ALL TABLES IN SCHEMA publication.

Ensure that the new owner of ALL TABLES IN SCHEMA publication must be a
superuser. The same is already ensured during CREATE PUBLICATION.

Author: Vignesh C
Reviewed-by: Nathan Bossart, Greg Nancarrow, Michael Paquier, Haiying Tang
Discussion: https://postgr.es/m/CALDaNm0E5U-RqxFuFrkZrQeG7ae5trGa=xs=iRtPPHULtT4zOw@mail.gmail.com

Files

PathChange+/−
src/backend/catalog/pg_publication.c modified +30 −0
src/backend/commands/publicationcmds.c modified +7 −0
src/include/catalog/pg_publication.h modified +1 −0
src/test/regress/expected/publication.out modified +15 −0
src/test/regress/sql/publication.sql modified +15 −0

Discussion