On Tue, 5 Nov 2019 14:29:00 +1300, David Rowley <david.rowley@xxxxxxxxxxxxxxx> wrote: >See https://www.postgresql.org/docs/current/sql-set.html > >"SET only affects the value used by the current session." > >Also: > >"The effects of SET LOCAL last only till the end of the current transaction" > >Neither affects other sessions. Ok, so you need to "ALTER DATABASE ..." for the change to affect everyone. Thanks for the clarification. George
