On Tue, 5 Nov 2019 14:29:00 +1300, David Rowley
<david(dot)rowley(at)2ndquadrant(dot)com> 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