Fujii Masao <masao.fu...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
