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