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

From Kevin Grittner
Subject pgsql: WAL-log the extension of a new empty MV heap which is being popu
Date
Msg-id E1UDNZo-0001vH-IG@gemulon.postgresql.org
Whole thread Raw
List 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 by date:

Previous
From: Kevin Grittner
Date:
Subject: pgsql: Add docs for pg_matviews, which were missed in the initial MV co
Next
From: Tom Lane
Date:
Subject: pgsql: Fix missing #include in commands/matview.h.