From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
---|---|
To: | Laurent Sartran <lsartran(at)gmail(dot)com> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Cannot create matview when referencing another not-populated-yet matview in subquery |
Date: | 2013-11-02 23:45:02 |
Message-ID: | 1383435902.37496.YahooMailNeo@web162905.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2013-11-03 03:41:44 | Re: How can I run a PostgreSQL database outside /var/run/postgresql? |
Previous Message | Kevin Grittner | 2013-11-02 22:13:35 | Re: How can I run a PostgreSQL database outside /var/run/postgresql? |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-11-03 00:05:24 | Re: missing locking in at least INSERT INTO view WITH CHECK |
Previous Message | Michael Paquier | 2013-11-02 23:28:05 | Re: Creating Empty Index |