Re: log_line_prefix: make it possible to add the search_path

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: log_line_prefix: make it possible to add the search_path
Дата
Msg-id 20220725095241.uc4khzuswchlh2va@alvherre.pgsql
обсуждение исходный текст
Ответ на log_line_prefix: make it possible to add the search_path  (Pierre Ducroquet <p.psql@pinaraf.info>)
Ответы Re: log_line_prefix: make it possible to add the search_path  (Pierre <p.psql@pinaraf.info>)
Список pgsql-hackers
On 2022-Jul-25, Pierre Ducroquet wrote:

> This is great for performance, but several tools are lacking around this 
> usecase by not showing the schema, one of them being log_line_prefix.

> The attached patch implements this, using %S. I've not written the 
> documentation yet, since I'm not sure this would be acceptable as is, or if a 
> more "generic" method should be used (I thought of %{name} to fetch an 
> arbitrary GUC, but did not implement due to a lack of need for that feature)

It seems that this would be too noisy to be truly usable.  What if we
emitted a log line when the variable changed, and the value that's in
use when the connection starts?

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica" (Irulan)



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Make name optional in CREATE STATISTICS
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Proposal to provide the facility to set binary format output for specific OID's per session