Re: Prevent conflicting SET options from being set

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: Prevent conflicting SET options from being set
Дата
Msg-id d1o2li$5oe$1@news.hub.org
обсуждение исходный текст
Ответ на Prevent conflicting SET options from being set  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Ответы Re: Prevent conflicting SET options from being set
Список pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes
>
> We already have the ability to issue custom messages in assign_hooks,
> and I think that's sufficient in practice.

Yes, I agree this is already sufficient - seems we need to remove that TODO
item in the list.

>
> A bigger problem with making cross-variable validity checks is that you
> can't really do it per-variable without falling foul of ordering
> considerations.  For instance, the existing checks in
> assign_stage_log_stats and assign_log_stats are ill-considered because
> they may reject a postgresql.conf file that turns one variable on before
> turning the other off.
>

This problem also applies to "debug_pretty_print" and "debug_print_parse". A
possible but costly solution is that after each SET, we have to validate
*all* the GUC variables again to see if there is any conflicts.

Regards,
Qingqing




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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: psql and pg_dump using obselete copy commands
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Using new copy libpq functions on a v2 protocol backend