pgsql: WAL-log the extension of a new empty MV heap which is being popu

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема pgsql: WAL-log the extension of a new empty MV heap which is being popu
Дата
Msg-id E1UDNZo-0001vH-IG@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
WAL-log the extension of a new empty MV heap which is being populated.

This page with no tuples is used to distinguish an MV containing a
zero-row resultset of its backing query from an MV which has not
been populated by its backing query.  Unless WAL-logged, recovery
and hot standby don't work correctly with what should be an empty
but scannable materialized view.

Fixes bugs reported by Fujii Masao in testing MVs on hot standby.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c5bf7a2052c8e7ebbd1ca3986525c3629d7345d1

Modified Files
--------------
src/backend/commands/matview.c |    8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)


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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: pgsql: Add docs for pg_matviews, which were missed in the initial MV co
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix missing #include in commands/matview.h.