pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Nathan Bossart <nathandbossart@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Yugo NAGATA <nagata@sraoss.co.jp>
Cc: Noah Misch <noah@leadboat.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers@postgresql.org, Joe Conway <mail@joeconway.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Subject: Re: MAINTAIN privilege -- what do we need to un-revert it?
Date: Fri, 27 Sep 2024 15:04:46 -0500
Message-ID: <ZvcP3noB7PU4lwA9@nathan> (raw)
In-Reply-To: <bfbcf235ee774ab4b6225dfba7be25a60ac01808.camel@j-davis.com>
References: <20240726122630.70e889f63a4d7e26f8549de8@sraoss.co.jp>
	<a7ce2ffa94cb26e40acf0ed8de857425f4d74727.camel@j-davis.com>
	<20240731182012.45d8231608896732395fc81a@sraoss.co.jp>
	<6bf8a76ebf3215d2226dbc2245d351aae577e4c1.camel@j-davis.com>
	<20240802161301.d975daca9ba7a706fa05ecd7@sraoss.co.jp>
	<20240805160502.d2a4975802a832b1e04afb80@sraoss.co.jp>
	<ZvXTErNZY-4HizMM@nathan>
	<20240927124234.c5c18d6448c98b52fad62834@sraoss.co.jp>
	<ZvbQknlG7dG21EUE@nathan>
	<bfbcf235ee774ab4b6225dfba7be25a60ac01808.camel@j-davis.com>

On Fri, Sep 27, 2024 at 09:22:48AM -0700, Jeff Davis wrote:
> I suggest that we add the wording to the
> <replaceable>query</replaceable> portion of the doc, near "security-
> restricted operation".

How does this look?

inline patch 1: doc/src/sgml/ref/create_materialized_view.sgml (+3/-1 lines) download inline-1.patch
diff --git a/doc/src/sgml/ref/create_materialized_view.sgml b/doc/src/sgml/ref/create_materialized_view.sgml
index 0d2fea2b97..62d897931c 100644
--- a/doc/src/sgml/ref/create_materialized_view.sgml
+++ b/doc/src/sgml/ref/create_materialized_view.sgml
@@ -143,7 +143,9 @@ CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] <replaceable>table_name</replaceable>
       A <link linkend="sql-select"><command>SELECT</command></link>, <link linkend="sql-table"><command>TABLE</command></link>,
       or <link linkend="sql-values"><command>VALUES</command></link> command.  This query will run within a
       security-restricted operation; in particular, calls to functions that
-      themselves create temporary tables will fail.
+      themselves create temporary tables will fail.  Also, while the query is
+      running, the <xref linkend="guc-search-path"/> is temporarily changed to
+      <literal>pg_catalog, pg_temp</literal>.
      </para>
     </listitem>
    </varlistentry>

-- 
nathan

view thread (30+ messages)  latest in thread

Message-ID: <ZvcP3noB7PU4lwA9@nathan>
Permalink:  ../ZvcP3noB7PU4lwA9@nathan/
Also on:    postgresql.org/message-id/ZvcP3noB7PU4lwA9@nathan

copy link · copy postgr.es · copy git am

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, pgsql@j-davis.com, nagata@sraoss.co.jp, noah@leadboat.com, michael@paquier.xyz, mail@joeconway.com, robertmhaas@gmail.com
  Subject: Re: MAINTAIN privilege -- what do we need to un-revert it?
  In-Reply-To: <ZvcP3noB7PU4lwA9@nathan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox