Thread

1. more suitable messages for analyze on hot standby.

   Tomonari Katsumata <t.katsumata1122@gmail.com> — 2012-10-08T01:04:48Z

   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
   

2. Re: more suitable messages for analyze on hot standby.

   Heikki Linnakangas <hlinnakangas@vmware.com> — 2012-10-08T11:27:24Z

   On 08.10.2012 04:04, Tomonari Katsumata wrote:
   > I work with streaming replication and hot standby.
   > And I noticed that error message is not proper when I issue
   > ANALYZE command to standby.
   >
   > ...
    >
   > This is not big problem, but error message should report
   > actual thing. please check it.
   
   Thanks, committed with some stylistic changes.
   
   - Heikki