Postgres Pro
Downloads
Home   >   mailing lists

Re: MAINTAIN privilege -- what do we need to un-revert it? - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: MAINTAIN privilege -- what do we need to un-revert it?
Date
Msg-id ZvXTErNZY-4HizMM@nathan
Whole thread Raw
In response to Re: MAINTAIN privilege -- what do we need to un-revert it?  (Yugo Nagata <nagata@sraoss.co.jp>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Large expressions in indexes can't be stored (non-TOASTable)
Next
From: Thomas Munro
Date:
Subject: Re: AIO writes vs hint bits vs checksums