Kevin Grittner <kgrittn@ymail.com> wrote:
> Laurent Sartran <lsartran@gmail.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