> 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 You probably want to do this rather than try to intercept every single operation in order to the reset at the end. -- -- Christophe Pettus xof@xxxxxxxxxxxx
