pgsql: When creating materialized views, use REFRESH to load data.

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема pgsql: When creating materialized views, use REFRESH to load data.
Дата
Msg-id E1sTqu7-001x1z-Sw@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
When creating materialized views, use REFRESH to load data.

Previously, CREATE MATERIALIZED VIEW ... WITH DATA populated the MV
the same way as CREATE TABLE ... AS.

Instead, reuse the REFRESH logic, which locks down security-restricted
operations and restricts the search_path. This reduces the chance that
a subsequent refresh will fail.

Reported-by: Noah Misch
Backpatch-through: 17
Discussion: https://postgr.es/m/20240630222344.db.nmisch@google.com

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b4da732fd64e936970f38c792f8b32c4bdf2bcd5

Modified Files
--------------
src/backend/commands/createas.c         | 32 ++++++++---------
src/backend/commands/matview.c          | 64 ++++++++++++++++++++-------------
src/include/commands/matview.h          |  3 ++
src/test/regress/expected/namespace.out |  4 +--
4 files changed, 60 insertions(+), 43 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: pgsql: When creating materialized views, use REFRESH to load data.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pgsql: Adjust recently added test for pg_signal_autovacuum role