Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wTOs9-000VGQ-2F
	for pgsql-hackers@arkaria.postgresql.org;
	Sat, 30 May 2026 18:57:25 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wTOs8-006JDU-0M
	for pgsql-hackers@arkaria.postgresql.org;
	Sat, 30 May 2026 18:57:24 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <bruce@momjian.us>)
	id 1wTOs7-006JDL-2g
	for pgsql-hackers@lists.postgresql.org;
	Sat, 30 May 2026 18:57:24 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <bruce@momjian.us>)
	id 1wTOs6-00000000LlV-05Bb
	for pgsql-hackers@lists.postgresql.org;
	Sat, 30 May 2026 18:57:23 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us;
	s=2026010100; h=In-Reply-To:Content-Transfer-Encoding:Content-Type:
	MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To:
	Content-ID:Content-Description;
	bh=mkWApdDJHZi64Qcq0uRIJUB/eqpUdLgyMRfiDKCG4mQ=; b=Ky7ZBPDBKmx49PcZKj71keoaE1
	NFvlIY5YjgPYOs9AKnQ/L6y5d8+sDvX1jyizikx4soFoK/6YST0x9WNR10P7gRNbeTjzPoZdmPE7C
	sGg3JRkUDDAltFAyW8qMpWihHZgxfWpJvvUp8wrCqTvCqvVMPzc597NsJHoeP5GVrcVWHDlzuY283
	TMmraKyMAked9N9xP8KoGSNYWZrvLtXoeqMlEWsnldm2jU5qeHMyuTjZtbzDb8R8xJvC9aaqQ6wQu
	ZkNV8EF8nNChWCmfl/42B01/vHZoOQxln6B9HKAhdGK8aKQisqG6GSV9iwiVjk9/sw4RRrYkT71lc
	1yHdEKJQ==;
Received: from bruce by momjian.us with local (Exim 4.98.2)
	(envelope-from <bruce@momjian.us>)
	id 1wTOrz-00000008DfE-1DuS;
	Sat, 30 May 2026 14:57:15 -0400
Date: Sat, 30 May 2026 14:57:15 -0400
From: Bruce Momjian <bruce@momjian.us>
To: =?utf-8?B?5b2t5Yay?= <chong.peng@enmotech.com>
Cc: Peter Geoghegan <pg@bowt.ie>,
	PostgreSQL-development <pgsql-hackers@lists.postgresql.org>,
	Chao Li <li.evan.chao@gmail.com>
Subject: Re: First draft of PG 19 release notes
Message-ID: <ahszC5QE2aRMJqf7@momjian.us>
References: <tencent_5468291122A490C6578D9467@qq.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="clcDEeQpMbCLT30V"
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <tencent_5468291122A490C6578D9467@qq.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/ahszC5QE2aRMJqf7%40momjian.us>
Precedence: bulk


--clcDEeQpMbCLT30V
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit

On Fri, May 29, 2026 at 11:30:28AM +0800, 彭冲 wrote:
> Hi, Bruce
> 
> ```
> 
> <listitem>
> <para>
> Modify pg_read_all_data() and pg_write_all_data() to read/write large objects (Nitin Motiani, Nathan Bossart)
> <ulink url="&commit_baseurl;d98197602">&sect;</ulink>
> </para>
> 
> <para>
> These functions are designed to allow non-super users to run pg_dump.
> </para>
> </listitem>
> 
> ```
> 
> 
> I found the feature description is inaccurate.: “pg_read_all_data” and “pg_write_all_data” are system roles.
> 
> Besides, i think this feature should not category to Functions.

Ah, very good point.  It item reworded and moved to the server
configuration section.  Patch attached and applied.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.

--clcDEeQpMbCLT30V
Content-Type: text/x-diff; charset=utf-8
Content-Disposition: attachment; filename="master.diff"
Content-Transfer-Encoding: 8bit

commit 3e744cc745b
Author: Bruce Momjian <bruce@momjian.us>
Date:   Sat May 30 14:55:32 2026 -0400

    doc PG 19 relnotes:  adjust pg_read_all_data & pg_write_all_data
    
    These were previously marked as functions, not roles, and were in the
    wrong section.
    
    Reported-by: 彭冲 <chong.peng@enmotech.com>
    
    Discussion: https://postgr.es/m/tencent_5468291122A490C6578D9467@qq.com

diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 6378542b455..ee063d2417e 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -1298,6 +1298,22 @@ This is an improved version of PQAUTHDATA_OAUTH_BEARER_TOKEN by adding the issue
 </para>
 </listitem>
 
+<!--
+Author: Nathan Bossart <nathan@postgresql.org>
+2026-02-23 [d98197602] Allow pg_{read,write}_all_data to access large objects.
+-->
+
+<listitem>
+<para>
+Allow roles pg_read_all_data and pg_write_all_data to read/write large objects (Nitin Motiani, Nathan Bossart)
+<ulink url="&commit_baseurl;d98197602">&sect;</ulink>
+</para>
+
+<para>
+These roles are designed to allow non-super users to run pg_dump.
+</para>
+</listitem>
+
 <!--
 Author: Michael Paquier <michael@paquier.xyz>
 2026-01-06 [f1e251be8] Allow bgworkers to be terminated for database-related co
@@ -2265,22 +2281,6 @@ The Dutch stemmer has also been updated.  The old Dutch stemmer is available via
 </para>
 </listitem>
 
-<!--
-Author: Nathan Bossart <nathan@postgresql.org>
-2026-02-23 [d98197602] Allow pg_{read,write}_all_data to access large objects.
--->
-
-<listitem>
-<para>
-Modify pg_read_all_data() and pg_write_all_data() to read/write large objects (Nitin Motiani, Nathan Bossart)
-<ulink url="&commit_baseurl;d98197602">&sect;</ulink>
-</para>
-
-<para>
-These functions are designed to allow non-super users to run pg_dump.
-</para>
-</listitem>
-
 <!--
 Author: Andrew Dunstan <andrew@dunslane.net>
 2026-04-05 [76e514ebb] Add pg_get_role_ddl() function

--clcDEeQpMbCLT30V--