pgsql: doc: Note that CREATE MATERIALIZED VIEW restricts search_path.

2024-09-27 Thread Nathan Bossart
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 t

pgsql: doc: Note that CREATE MATERIALIZED VIEW restricts search_path.

2024-09-27 Thread Nathan Bossart
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 t