Kevin Grittner <kgri...@ymail.com> wrote:
> Laurent Sartran <lsart...@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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to