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

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers(at)postgresql(dot)org, Joe Conway <mail(at)joeconway(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: MAINTAIN privilege -- what do we need to un-revert it?
Date: 2024-09-26 21:33:06
Message-ID: ZvXTErNZY-4HizMM@nathan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2024-09-26 21:56:34 Re: AIO writes vs hint bits vs checksums
Previous Message Nathan Bossart 2024-09-26 20:53:33 Re: Large expressions in indexes can't be stored (non-TOASTable)