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

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix changing the ownership of ALL TABLES IN SCHEMA publication.
Date: 2021-12-08 06:13:50
Message-ID: E1muqD8-00033X-Nh@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2021-12-08 08:49:27 pgsql: pgrowlocks: Fix incorrect format placeholders
Previous Message Amit Kapila 2021-12-08 05:58:56 pgsql: De-duplicate the result of pg_publication_tables view.