Re: [HACKERS] odd behavior in materialized view

2013-03-26 Thread Kevin Grittner
Fujii Masao masao.fu...@gmail.com wrote: Ping? ISTM this problem has not been fixed in HEAD yet. It's next on my list.  The other reports seemed more serious and more likely to be contentious in terms of the best fix. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise

Re: [HACKERS] odd behavior in materialized view

2013-03-25 Thread Fujii Masao
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

Re: [HACKERS] odd behavior in materialized view

2013-03-09 Thread Fujii Masao
On Fri, Mar 8, 2013 at 2:42 AM, Kevin Grittner kgri...@ymail.com wrote: Fujii Masao masao.fu...@gmail.com wrote: I found one typo in the document of MV. Please see the attached patch. Pushed. Thanks! Thanks! I found that pg_dump always fails against 9.2 or before server because of the MV

Re: [HACKERS] odd behavior in materialized view

2013-03-07 Thread Fujii Masao
On Thu, Mar 7, 2013 at 8:21 AM, Kevin Grittner kgri...@ymail.com wrote: Fujii Masao masao.fu...@gmail.com wrote: On Tue, Mar 5, 2013 at 7:36 AM, Kevin Grittner kgri...@ymail.com wrote: Fujii Masao masao.fu...@gmail.com wrote: When I accessed the materialized view in the standby server, I

Re: [HACKERS] odd behavior in materialized view

2013-03-07 Thread Kevin Grittner
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

Re: [HACKERS] odd behavior in materialized view

2013-03-07 Thread Fujii Masao
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

Re: [HACKERS] odd behavior in materialized view

2013-03-07 Thread Kevin Grittner
Fujii Masao masao.fu...@gmail.com wrote: I found one typo in the document of MV. Please see the attached patch. Pushed.  Thanks! -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list

Re: [HACKERS] odd behavior in materialized view

2013-03-06 Thread Kevin Grittner
Fujii Masao masao.fu...@gmail.com wrote: On Tue, Mar 5, 2013 at 7:36 AM, Kevin Grittner kgri...@ymail.com wrote: 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?

Re: [HACKERS] odd behavior in materialized view

2013-03-05 Thread Fujii Masao
On Tue, Mar 5, 2013 at 7:36 AM, Kevin Grittner kgri...@ymail.com wrote: 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

Re: [HACKERS] odd behavior in materialized view

2013-03-05 Thread Kevin Grittner
Fujii Masao masao.fu...@gmail.com wrote: And I found another problem. When I ran the following SQLs in the master, PANIC error occurred in the standby. CREATE TABLE hoge (i int); INSERT INTO hoge VALUES (generate_series(1,100)); CREATE MATERIALIZED VIEW hogeview AS SELECT * FROM

[HACKERS] odd behavior in materialized view

2013-03-04 Thread Fujii Masao
Hi, 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

Re: [HACKERS] odd behavior in materialized view

2013-03-04 Thread Kevin Grittner
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