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
|
| Список | 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 по дате отправления: