Christophe Pettus <xof@xxxxxxxxxxxx> writes: >> On Jan 24, 2021, at 21:00, Andrew Stuart <andrew@xxxxxxxxxxxxxxxx> wrote: >> Can anyone suggest if session variables can be SET/RESET using Postgres rules, or optionally perhaps there is a better way to do so? > PostgreSQL poolers generally use the RESET ALL command when reassigning a session to clear the session state: > https://www.postgresql.org/docs/current/sql-reset.html See also DISCARD, which clears even more session state: https://www.postgresql.org/docs/current/sql-discard.html I concur that trying to use rules for this is unlikely to work well. regards, tom lane
