v1-0001-Improve-documentation-of-publication-privilege-ch.patch
application/octet-stream
Filename: v1-0001-Improve-documentation-of-publication-privilege-ch.patch
Type: application/octet-stream
Part: 0
From 4a652cbfd2e490d89594375b042b5d8719933027 Mon Sep 17 00:00:00 2001 From: Shlok Kyal <shlok.kyal.oss@gmail.com> Date: Tue, 23 Dec 2025 14:22:06 +0530 Subject: [PATCH v1] Improve documentation of publication privilege checks Make the logical replication documentation explicitly describe the privilege requirements for different publication syntaxes. --- doc/src/sgml/logical-replication.sgml | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index b3faaa675ef..7d8413d7c6b 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -2550,10 +2550,12 @@ CONTEXT: processing remote data for replication origin "pg_16395" during "INSER </para> <para> - To add tables to a publication, the user must have ownership rights on the - table. To add all tables in schema to a publication, the user must be a - superuser. To create a publication that publishes all tables, all tables in - schema, or all sequences automatically, the user must be a superuser. + To create a publication using <literal>FOR ALL TABLES</literal>, + <literal>FOR ALL SEQUENCES</literal> or + <literal>FOR TABLES IN SCHEMA</literal>, the user must be a superuser. To add + <literal>TABLES IN SCHEMA</literal> to a publication, the user must be a + superuser. To add tables to a publication, the user must have ownership + rights on the table. </para> <para> -- 2.34.1