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

From: Kevin Grittner <kgrittn(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix subquery reference to non-populated MV in CMV.
Date: 2013-11-02 23:40:42
Message-ID: E1Vcko6-0002fw-Jm@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
master

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

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Kevin Grittner 2013-11-03 00:22:20 pgsql: Acquire appropriate locks when rewriting during RMV.
Previous Message Tom Lane 2013-11-02 20:46:38 pgsql: Retry after buffer locking failure during SPGiST index creation.