Обсуждение: pgsql: Fix subquery reference to non-populated MV in CMV.

Поиск
Список
Период
Сортировка

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

От
Kevin Grittner
Дата:
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(-)