On Fri, Mar 8, 2013 at 1:52 AM, Kevin Grittner <kgri...@ymail.com> wrote: > Fujii Masao <masao.fu...@gmail.com> wrote: > >> Thanks! I confirmed that the problem that I reported has >> disappeared in HEAD. >> >> Unfortunately I found another odd behavior. When I accessed the >> MV after VACUUM ANALYZE, I got the following error. >> >> ERROR: materialized view "hogeview" has not been populated >> HINT: Use the REFRESH MATERIALIZED VIEW command. >> STATEMENT: select * from hogeview where i < 10; >> >> The test case to reproduce that is: >> >> create table hoge (i int); >> insert into hoge values (generate_series(1,100000)); >> create materialized view hogeview as select * from hoge where i % 2 = 0; >> create index hogeviewidx on hogeview (i); >> delete from hoge; >> refresh materialized view hogeview; >> select * from hogeview where i < 10; >> vacuum analyze; >> select * from hogeview where i < 10; >> >> The last SELECT command caused the above error. > > Thanks. Will fix.
Thanks! I found one typo in the document of MV. Please see the attached patch. Regards, -- Fujii Masao
typo.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers