On Thu, 26 Sep 2024 16:33:06 -0500 Nathan Bossart <nathandboss...@gmail.com> wrote:
> On Mon, Aug 05, 2024 at 04:05:02PM +0900, Yugo Nagata wrote: > > + <para> > > + While <command>CREATE MATERIALIZED VIEW</command> is running, the <xref > > + linkend="guc-search-path"/> is temporarily changed to > > <literal>pg_catalog, > > + pg_temp</literal>. > > + </para> > > I think we should mention that this is not true when WITH NO DATA is used. > Maybe something like: > > Unless WITH NO DATA is used, the search_path is temporarily changed to > pg_catalog, pg_temp while CREATE MATERIALIZED VIEW is running. > I agree with you. I overlooked WITH NO DATA. I attached a updated patch. Regards, Yugo Nagata -- Yugo NAGATA <nag...@sraoss.co.jp>
diff --git a/doc/src/sgml/ref/create_materialized_view.sgml b/doc/src/sgml/ref/create_materialized_view.sgml index 0d2fea2b97..2fdc210c27 100644 --- a/doc/src/sgml/ref/create_materialized_view.sgml +++ b/doc/src/sgml/ref/create_materialized_view.sgml @@ -163,6 +163,17 @@ CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] <replaceable>table_name</replaceable> </variablelist> </refsect1> + <refsect1> + <title>Notes</title> + + <para> + Unless <command>WITH NO DATA</command> is used, the <xref + linkend="guc-search-path"/> is temporarily changed to + <literal>pg_catalog, pg_temp</literal> while + <command>CREATE MATERIALIZED VIEW</command> is running. + </para> + </refsect1> + <refsect1> <title>Compatibility</title>
