On Monday, April 21, 2025, PG Doc comments form <
noreply@postgresql.org> wrote:
It seems that the assumed/implied default value for settings that did not
exist for a session is the empty string? It would be useful to document that
behavior explicitly.
This is presently being worked on. Some changes have made it into the v18 docs already.
Furthermore, it seems impossible to actually *remove* such a user defined
settings completely, correct? That too, I miss stated explicitly in the
documentation.
Correct. The null is not the value of the setting, it is being provided instead of producing a “setting does not exist” error.
The system never forgets a setting once set (within a session). Reset restores a setting to its default value, which for text is the empty string.
David J.