odd behavior in materialized view

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема odd behavior in materialized view
Дата
Msg-id CAHGQGwHuee=mM419pmDz9_3F0rgJoiFmifv7Mt11GS3MnL94YQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: odd behavior in materialized view  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-hackers
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 is:

In the master server:   CREATE TABLE hoge (i int);   INSERT INTO hoge VALUES (generate_series(1,100));   CREATE
MATERIALIZEDVIEW 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.

Regards,

-- 
Fujii Masao



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Enabling Checksums
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: sql_drop Event Trigger