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