On Sunday, July 13, 2025, KES <kes-kes(at)yandex(dot)ru> wrote:
> I suppose that DEFAULT syntax should be used to set setting to its default
> value. Eg.
> set_config( 'my.option', DEFAULT, false )
> This is clear what should happen here. Also this syntax will correspond to
> other places, eg. INSERT INTO xx (name) VALUES (DEFAULT).
>
> Using NULL to set reset the value to the default is very very confusing.
> set_config( 'my.option', NULL, false )
> Expected: this call should make option unrecognizable again.
>
I don’t see us changing this even if someone were willing to write a
patch. You will have to make do with the behavior that exists.
David J.