Re: log_line_prefix: make it possible to add the search_path - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: log_line_prefix: make it possible to add the search_path
Date
Msg-id 20220725095241.uc4khzuswchlh2va@alvherre.pgsql
Whole thread Raw
In response to log_line_prefix: make it possible to add the search_path  (Pierre Ducroquet <p.psql@pinaraf.info>)
Responses Re: log_line_prefix: make it possible to add the search_path
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Make name optional in CREATE STATISTICS
Next
From: Dave Cramer
Date:
Subject: Re: Proposal to provide the facility to set binary format output for specific OID's per session