Re: Unexpected behaviour: it was documented to return the same value

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Unexpected behaviour: it was documented to return the same value
Дата
Msg-id CAKFQuwbuLZf0TmWt5pUTOG0t+BY0DVO7TBXxgvU1fYD_ba0tGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Unexpected behaviour: it was documented to return the same value  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
On Sunday, July 13, 2025, KES <kes-kes@yandex.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.

В списке pgsql-docs по дате отправления: