Re: RESET, NULL and empty-string valued settings and transaction isolation

2024-10-19 Thread Marcelo Zabani
Thank you both for the explanations and the link to the discussion of Pavel's patches.

Re: RESET, NULL and empty-string valued settings and transaction isolation

2024-10-19 Thread Tom Lane
Marcelo Zabani writes: > Hi, according to the docs, RESET sets the value of a setting to > "The default value is defined as the value that the parameter would have > had, if no SET had ever been issued for it in the current session" This is, I guess, strictly true only for built-in settings. Cust

Re: RESET, NULL and empty-string valued settings and transaction isolation

2024-10-19 Thread David G. Johnston
On Saturday, October 19, 2024, Marcelo Zabani wrote: > Hi, according to the docs, RESET sets the value of a setting to > "The default value is defined as the value that the parameter would have > had, if no SET had ever been issued for it in the current session" > > Which confuses me given that t

RESET, NULL and empty-string valued settings and transaction isolation

2024-10-19 Thread Marcelo Zabani
Hi, according to the docs, RESET sets the value of a setting to "The default value is defined as the value that the parameter would have had, if no SET had ever been issued for it in the current session" Which confuses me given that the value starts being NULL in the session and then turns into an