From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
---|---|
To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: odd behavior in materialized view |
Date: | 2013-03-04 22:36:23 |
Message-ID: | 1362436583.60921.YahooMailNeo@web162902.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Fujii Masao <masao(dot)fujii(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2013-03-04 23:10:30 | Re: Suggested new CF status: "Pending Discussion" |
Previous Message | Maciek Sakrejda | 2013-03-04 22:27:17 | Re: [GENERAL] Floating point error |