more suitable messages for analyze on hot standby.
Tomonari Katsumata <t.katsumata1122@gmail.com>
From: Tomonari Katsumata <t.katsumata1122@gmail.com>
To: pgsql-hackers@postgresql.org
Date: 2012-10-08T01:04:48Z
Lists: pgsql-hackers
Attachments
- analyze_message_on_hotstandby.patch (application/octet-stream) patch
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. ======================================================== -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 revising the message. ======================================================== -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 report actual thing. please check it. regards, ------------- Tomonari Katsumata