error message is not proper for analyze on standby.

Поиск
Список
Период
Сортировка
От Tomonari Katsumata
Тема error message is not proper for analyze on standby.
Дата
Msg-id CAC55fYfbJa6JtxdAA4rEbSE6X4f1neJsvwd_N8Kcy=WKgeU-Ew@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hi,

I work with streaming replication and hot standby.
and I noticed that error message is not proper when I issue
ANALYZE command to standby.

[before]
========================================================
-bash-3.2$ psql -c "analyze"
ERROR:  cannot execute VACUUM during recovery
STATEMENT:  analyze
ERROR:  cannot execute VACUUM during recovery
========================================================

ANALYZE command is not VACUUM command.
I attached a patch revised the message.

[after]
========================================================
-bash-3.2$ psql -c "analyze"
ERROR:  cannot execute ANALYZE during recovery
STATEMENT:  analyze
ERROR:  cannot execute ANALYZE during recovery
========================================================

this is not big problem, but error message should be
report actual thing.
please check it.

regards,

-------------
Tomonari Katsumata

Вложения

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

Предыдущее
От: zafer yagmuroglu
Дата:
Сообщение: PQntuples and PQgetvalue problem.
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Promoting a standby during base backup (was Re: Switching timeline over streaming replication)