Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:
> However I was under the impression that if I did a pg_reload_conf(), the
> pg_settings view would be updated at that time, but that does not seem to
> happen.
It works for me ...
regression=# select setting from pg_settings where name = 'constraint_exclusion';
setting
---------
off
(1 row)
-- edit postgresql.conf in another window, set constraint_exclusion = on
regression=# select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)
regression=# select setting from pg_settings where name = 'constraint_exclusion';
setting
---------
on
(1 row)
regards, tom lane