pgsql: Fix changing the ownership of ALL TABLES IN SCHEMA publication.

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