Christophe Pettus <x...@thebuild.com> writes: >> On Jan 24, 2021, at 21:00, Andrew Stuart <and...@salesgrid.com.au> 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
