Tony Caduto <tony_caduto@amsoftwaredesign.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