Re: [HACKERS] odd behavior in materialized view

2013-03-26 Thread Kevin Grittner
Fujii Masao 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 PostgreSQL Company -

Re: [HACKERS] odd behavior in materialized view

2013-03-25 Thread Fujii Masao
On Fri, Mar 8, 2013 at 1:52 AM, Kevin Grittner wrote: > Fujii Masao 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. >> >> E

Re: [HACKERS] odd behavior in materialized view

2013-03-09 Thread Fujii Masao
On Fri, Mar 8, 2013 at 2:42 AM, Kevin Grittner wrote: > Fujii Masao 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 patch. $ pg_dump pg_dump: [arc

Re: [HACKERS] odd behavior in materialized view

2013-03-07 Thread Kevin Grittner
Fujii Masao 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 (pgsql-hackers@postgresql.org) To make changes t

Re: [HACKERS] odd behavior in materialized view

2013-03-07 Thread Fujii Masao
On Fri, Mar 8, 2013 at 1:52 AM, Kevin Grittner wrote: > Fujii Masao 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. >> >> E

Re: [HACKERS] odd behavior in materialized view

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

Re: [HACKERS] odd behavior in materialized view

2013-03-07 Thread Fujii Masao
On Thu, Mar 7, 2013 at 8:21 AM, Kevin Grittner wrote: > Fujii Masao wrote: >> On Tue, Mar 5, 2013 at 7:36 AM, Kevin Grittner wrote: >>> Fujii Masao wrote: >>> When I accessed the materialized view in the standby server, >>> I got the following ERROR message. Looks odd to me. Is this a

Re: [HACKERS] odd behavior in materialized view

2013-03-06 Thread Kevin Grittner
Fujii Masao wrote: > On Tue, Mar 5, 2013 at 7:36 AM, Kevin Grittner wrote: >> Fujii Masao 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

Re: [HACKERS] odd behavior in materialized view

2013-03-05 Thread Kevin Grittner
Fujii Masao 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 hoge; > VAC

Re: [HACKERS] odd behavior in materialized view

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

Re: [HACKERS] odd behavior in materialized view

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

[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