pgsql: Fix subquery reference to non-populated MV in CMV. - Mailing list pgsql-committers

From Kevin Grittner
Subject pgsql: Fix subquery reference to non-populated MV in CMV.
Date
Msg-id E1Vcko6-0002fz-LK@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix subquery reference to non-populated MV in CMV.

A subquery reference to a matview should be allowed by CREATE
MATERIALIZED VIEW WITH NO DATA, just like a direct reference is.

Per bug report from Laurent Sartran.

Backpatch to 9.3.

Branch
------
REL9_3_STABLE

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

Modified Files
--------------
src/backend/executor/execMain.c       |    3 ++-
src/test/regress/expected/matview.out |    6 ++++++
src/test/regress/sql/matview.sql      |    6 ++++++
3 files changed, 14 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Retry after buffer locking failure during SPGiST index creation.
Next
From: Kevin Grittner
Date:
Subject: pgsql: Fix subquery reference to non-populated MV in CMV.