Fujii Masao <masao.fujii@gmail.com> wrote:
> When I accessed the materialized view in the standby server,
> I got the following ERROR message. Looks odd to me. Is this a bug?
>
> ERROR: materialized view "hogeview" has not been populated
> HINT: Use the REFRESH MATERIALIZED VIEW command.
>
> The procedure to reproduce this error message is:
>
> In the master server:
> CREATE TABLE hoge (i int);
> INSERT INTO hoge VALUES (generate_series(1,100));
> CREATE MATERIALIZED VIEW hogeview AS SELECT * FROM hoge;
> DELETE FROM hoge;
> REFRESH MATERIALIZED VIEW hogeview;
> SELECT count(*) FROM hogeview;
>
> In the standby server
> SELECT count(*) FROM hogeview;
>
> SELECT count(*) goes well in the master, and expectedly returns 0.
> OTOH, in the standby, it emits the error message.
Will investigate.
Thanks for testing!
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company