Tony Caduto <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
