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=irtpphultt4...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/1a2aaeb0db1bccd97140d479c4247127f6cb9378 Modified Files -------------- src/backend/catalog/pg_publication.c | 30 ++++++++++++++++++++++++++++++ src/backend/commands/publicationcmds.c | 7 +++++++ src/include/catalog/pg_publication.h | 1 + src/test/regress/expected/publication.out | 15 +++++++++++++++ src/test/regress/sql/publication.sql | 15 +++++++++++++++ 5 files changed, 68 insertions(+)
