pgsql: Fix changing the ownership of ALL TABLES IN SCHEMA publication. - Mailing list pgsql-committers

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

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(+)