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
Message: Improve documentation of publication privilege checks
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