Date: Mon, 7 Oct 2024 20:00:45 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Yugo NAGATA <nagata@sraoss.co.jp>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: First draft of PG 17 release notes
Message-ID: <ZwR2LeVXX7HrtkcN@momjian.us>
References: <ZjxLJpnH4VMkOMmi@momjian.us>
 <20240926141921.57d0b430fa53ac4389344847@sraoss.co.jp>
 <ZvirD5wt70As4hI_@momjian.us>
 <20240930142021.3776c6ebe5a35849719084fd@sraoss.co.jp>
 <ZwRt123fgr78pu5a@momjian.us>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="T1abxZ1OLE27TlU1"
Content-Disposition: inline
In-Reply-To: <ZwRt123fgr78pu5a@momjian.us>
Archived-At: <https://www.postgresql.org/message-id/ZwR2LeVXX7HrtkcN%40momjian.us>
Precedence: bulk


--T1abxZ1OLE27TlU1
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Mon, Oct  7, 2024 at 07:25:11PM -0400, Bruce Momjian wrote:
> > Yes. This change on CREATE INDEX was introduced by 2af07e2f7 together with
> > other commands, but it was missed to be mentioned in the commit message
> > although the description was added to the documentation.
> > 
> > The change on CEATE MATERIALIZED VIEW was introduced by a separate commit
> > b4da732fd, since which the REFRESH logic is used when creating a matview.
> > Should we add here a link to that commit, too?
> 
> I developed the attached patch which adds the two commands and the
> commit item.

Okay, updated commit after running src/tools/add_commit_links.pl.

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

  When a patient asks the doctor, "Am I going to die?", he means 
  "Am I going to die soon?"

--T1abxZ1OLE27TlU1
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="REL_17_STABLE_schema.diff"

diff --git a/doc/src/sgml/release-17.sgml b/doc/src/sgml/release-17.sgml
index ad814737745..0ea9d96a47f 100644
--- a/doc/src/sgml/release-17.sgml
+++ b/doc/src/sgml/release-17.sgml
@@ -125,6 +125,8 @@
 <!--
 Author: Jeff Davis <jdavis@postgresql.org>
 2024-03-04 [2af07e2f7] Fix search_path to a safe value during maintenance opera
+Author: Jeff Davis <jdavis@postgresql.org>
+2024-07-16 [b4da732fd64] When creating materialized views, use REFRESH to load data.
 -->
 
     <listitem>
@@ -132,11 +134,14 @@ Author: Jeff Davis <jdavis@postgresql.org>
      Change functions to use a safe <xref linkend="guc-search-path"/>
      during maintenance operations (Jeff Davis)
      <ulink url="&commit_baseurl;2af07e2f7">&sect;</ulink>
+     <ulink url="&commit_baseurl;b4da732fd64">&sect;</ulink>
      </para>
 
      <para>
      This prevents maintenance operations (<command>ANALYZE</command>,
-     <command>CLUSTER</command>, <command>REFRESH
+     <command>CLUSTER</command>, <command>CREATE
+     INDEX</command>, <command>CREATE
+     MATERIALIZED VIEW</command>, <command>REFRESH
      MATERIALIZED VIEW</command>, <command>REINDEX</command>,
      or <command>VACUUM</command>) from performing unsafe access.
      Functions used by expression indexes and materialized views that

--T1abxZ1OLE27TlU1--