Re: [GENERAL] Cannot create matview when referencing another not-populated-yet matview in subquery

Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:
> Laurent Sartran <lsartran(at)gmail(dot)com> wrote:

>> CREATE MATERIALIZED VIEW t1 AS SELECT text 'foo' AS col1
>>    WITH NO DATA;
>> CREATE MATERIALIZED VIEW t2b AS SELECT * FROM t1
>>    WHERE col1 = (SELECT LEAST(col1) FROM t1)
>>    WITH NO DATA;
>>
>> ERROR:  materialized view "t1" has not been populated
>> HINT:  Use the REFRESH MATERIALIZED VIEW command.
>
>> Is this behavior expected?
>
> No, and git bisect shows that it worked until commit
> 5194024d72f33fb209e10f9ab0ada7cc67df45b7.

Fix committed.  Thanks for the report!

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company