Re: Server does not start when log_statement_stats is set to on

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Server does not start when log_statement_stats is set to on
Дата
Msg-id 9711.1198691074@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Server does not start when log_statement_stats is set to on  (Devrim GÜNDÜZ <devrim@CommandPrompt.com>)
Ответы Re: Server does not start when log_statement_stats is set to on  (Alvaro Herrera <alvherre@CommandPrompt.com>)
Список pgsql-bugs
Devrim GÜNDÜZ <devrim@CommandPrompt.com> writes:
> I'm getting this error when I set lot_statement_stats to on :
> FATAL: invalid value for parameter "log_statement_stats": 1

> Per Alexey (and Alvaro), both log_planner_stats and log_statement_stats
> cannot be turned on at the same time.

Yup:

regression=# set log_planner_stats TO 1;
SET
regression=# set log_statement_stats TO 1;
ERROR:  cannot enable "log_statement_stats" when "log_parser_stats", "log_planner_stats", or "log_executor_stats" is
true

> Is that documented somewhere,

Yes.

> or can we please improve the error message here -- or is it a bug?

It's not a bug.  However, the specific error message only comes out in
interactive-SET cases:
       if (source >= PGC_S_INTERACTIVE)           ereport(ERROR,
(errcode(ERRCODE_INVALID_PARAMETER_VALUE),                   errmsg("cannot enable \"log_statement_stats\" when "
                   "\"log_parser_stats\", \"log_planner_stats\", "                           "or \"log_executor_stats\"
istrue"))); 

There are a bunch of other GUC assign hooks that behave similarly.
Perhaps it'd be sensible to emit these complaints as LOG messages
when we're dealing with a noninteractive source (ie, the config file)?
        regards, tom lane


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

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Server does not start when log_statement_stats is set to on
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Server does not start when log_statement_stats is set to on