On Monday, April 21, 2025, PG Doc comments form <nore...@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.

Reply via email to