Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitd8ebcac

Browse files
doc: Note that CREATE MATERIALIZED VIEW restricts search_path.
Since v17, CREATE MATERIALIZED VIEW has set search_path to"pg_catalog, pg_temp" while running the query. The docs for theother commands that restrict search_path mention it, but the pagefor CREATE MATERIALIZED VIEW does not. Fix that.Oversight in commit4b74ebf.Author: Yugo NagataReviewed-by: Jeff DavisDiscussion:https://postgr.es/m/20240805160502.d2a4975802a832b1e04afb80%40sraoss.co.jpBackpatch-through: 17
1 parenta3179ab commitd8ebcac

File tree

1 file changed

+3
-1
lines changed

1 file changed

+3
-1
lines changed

‎doc/src/sgml/ref/create_materialized_view.sgml

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -143,7 +143,9 @@ CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] <replaceable>table_name</replaceable>
143143
A <link linkend="sql-select"><command>SELECT</command></link>, <link linkend="sql-table"><command>TABLE</command></link>,
144144
or <link linkend="sql-values"><command>VALUES</command></link> command. This query will run within a
145145
security-restricted operation; in particular, calls to functions that
146-
themselves create temporary tables will fail.
146+
themselves create temporary tables will fail. Also, while the query is
147+
running, the <xref linkend="guc-search-path"/> is temporarily changed to
148+
<literal>pg_catalog, pg_temp</literal>.
147149
</para>
148150
</listitem>
149151
</varlistentry>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp