"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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.
I repeated Tony's result (Win32):
Welcome to psql 8.1RC1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
test=# select setting from pg_settings where name = 'constraint_exclusion';
setting
---------
off
(1 row)
test=# select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)
test=# select setting from pg_settings where name = 'constraint_exclusion';
setting
---------
off
(1 row)
test=# LOG: received SIGHUP, reloading configuration files
test=# select setting from pg_settings where name = 'constraint_exclusion';
setting
---------
off
(1 row)
test=# select setting from pg_settings where name = 'constraint_exclusion';
setting
---------
on
(1 row)
-- Seems that's due to delay of process SIGHUP ...
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
