Re: MAINTAIN privilege -- what do we need to un-revert it?

[Nathan Bossart]

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.

-- 
nathan