On 18/10/2023 12:15, Tom Lane wrote:
Andrei Lepikhov <a.lepik...@postgrespro.ru> writes:
"SET foo.bar TO 'smth'" can immediately alter the placeholder's value.
But what is the reason that "ALTER SYSTEM SET foo.bar TO 'smth'" doesn't
do the same?
Because it's not supposed to take effect until you issue a reload
command (and maybe not even then, depending on which GUC we're
talking about). I certainly think it wouldn't make sense for your
own session to adopt the value ahead of others.
Thanks for the answer.
Introducing the assignable_custom_variable_name can be helpful. The code
looks good. I think it deserves to be committed - after the indentation
fix, of course.
--
regards,
Andrey Lepikhov
Postgres Professional
