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 <br...@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?"
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 <jda...@postgresql.org> 2024-03-04 [2af07e2f7] Fix search_path to a safe value during maintenance opera +Author: Jeff Davis <jda...@postgresql.org> +2024-07-16 [b4da732fd64] When creating materialized views, use REFRESH to load data. --> <listitem> @@ -132,11 +134,14 @@ Author: Jeff Davis <jda...@postgresql.org> Change functions to use a safe <xref linkend="guc-search-path"/> during maintenance operations (Jeff Davis) <ulink url="&commit_baseurl;2af07e2f7">§</ulink> + <ulink url="&commit_baseurl;b4da732fd64">§</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