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.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sxx6M-00DRjL-0g
	for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Oct 2024 23:25:18 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sxx6K-00H87l-Gd
	for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Oct 2024 23:25:16 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1sxx6K-00H87d-3O
	for pgsql-hackers@lists.postgresql.org; Mon, 07 Oct 2024 23:25:16 +0000
Received: from momjian.us ([72.94.173.45])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1sxx6H-0031l2-BV
	for pgsql-hackers@postgresql.org; Mon, 07 Oct 2024 23:25:14 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us;
	s=2024011501; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID:
	Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID:
	Content-Description; bh=rxaByjqmvM4DYrkkUFpcVqOm1/cY+Kl6z97JnCUqsSY=; b=FPNWM
	7gaGeSHtwr4nlJ6wwQno/OyH3CrjFd1YvohF0R5+0675wmTC1VsEonr7RLBQGYdupKuq+nxV3FVaP
	1K21c9Hn9T6dtsjDEOdMlfsFiIUy5dwSisZGoRU4tFrZ2/eoJqgdyhEcymRhbekHoKVXQU5mpU/9r
	I5Npy/S6N1QoBrYzyRA//1ttc2l9hw5RLv+mpE7SLz3vQTIshmoERT90N01afCPUHE1Cu091fRts3
	/IhedNp6J0Q1a1GinXT7BDfZ0u2kBGT0lG/qQNxvoUqpaeCgj3p+5vfIWLO0FoiWNNft0/yaRUAJ+
	FaWfAjItgPUWdT9Bip5QgQVt01g7g==;
Received: from bruce by momjian.us with local (Exim 4.96)
	(envelope-from <bruce@momjian.us>)
	id 1sxx6F-007hEi-2Y;
	Mon, 07 Oct 2024 19:25:11 -0400
Date: Mon, 7 Oct 2024 19:25:11 -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: <ZwRt123fgr78pu5a@momjian.us>
References: <ZjxLJpnH4VMkOMmi@momjian.us>
 <20240926141921.57d0b430fa53ac4389344847@sraoss.co.jp>
 <ZvirD5wt70As4hI_@momjian.us>
 <20240930142021.3776c6ebe5a35849719084fd@sraoss.co.jp>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="6kT+i4+EenZPYp5X"
Content-Disposition: inline
In-Reply-To: <20240930142021.3776c6ebe5a35849719084fd@sraoss.co.jp>
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/ZwRt123fgr78pu5a%40momjian.us>
Precedence: bulk


--6kT+i4+EenZPYp5X
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Mon, Sep 30, 2024 at 02:20:21PM +0900, Yugo NAGATA wrote:
> On Sat, 28 Sep 2024 21:19:11 -0400
> Bruce Momjian <bruce@momjian.us> wrote:
> 
> > On Thu, Sep 26, 2024 at 02:19:21PM +0900, Yugo Nagata wrote:
> > > On Thu, 9 May 2024 00:03:50 -0400
> > > Bruce Momjian <bruce@momjian.us> wrote:
> > > 
> > > > I have committed the first draft of the PG 17 release notes;  you can
> > > > see the results here:
> > > 
> > > I propose to improve the following description in "Migration to Version 17"
> > > section by adding CREATE INDEX and CREATE MATERIALIZED VIEW into the command list.
> > > 
> > >      <para>
> > >      Change functions to use a safe <xref linkend="guc-search-path"/>
> > >      during maintenance operations (Jeff Davis)
> > >      <ulink url="&commit_baseurl;2af07e2f7">&sect;</ulink>
> > >      </para>
> > > 
> > > It is suggested in the thread [1] that users could not notice the behaviour
> > > of CREATE INDEX is changed because the explicit command name is not listed in
> > > the release notes. So, I think it is better to add CREATE INDEX and
> > > CREATE MATERIALIZED VIEW into the command list. 
> > > 
> > > I've attached a patch.
> > 
> > It this a valid change?  Seems so.
> 
> 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.

-- 
  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?"

--6kT+i4+EenZPYp5X
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..7acdee05e42 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>
@@ -136,7 +138,9 @@ Author: Jeff Davis <jdavis@postgresql.org>
 
      <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

--6kT+i4+EenZPYp5X--