| From: | Nathan Bossart <nathan(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: doc: Note that CREATE MATERIALIZED VIEW restricts search_path. |
| Date: | 2024-09-27 21:22:19 |
| Message-ID: | E1suIPq-001Ckx-Sw@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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 the
other commands that restrict search_path mention it, but the page
for CREATE MATERIALIZED VIEW does not. Fix that.
Oversight in commit 4b74ebf726.
Author: Yugo Nagata
Reviewed-by: Jeff Davis
Discussion: https://postgr.es/m/20240805160502.d2a4975802a832b1e04afb80%40sraoss.co.jp
Backpatch-through: 17
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/18cea252ac74c185f754b3f0007921e7955ed1d6
Modified Files
--------------
doc/src/sgml/ref/create_materialized_view.sgml | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2024-09-27 22:32:14 | pgsql: Avoid 037_invalid_database.pl hang under debug_discard_caches. |
| Previous Message | Tom Lane | 2024-09-27 20:04:11 | pgsql: Recalculate where-needed data accurately after a join removal. |