Re:How We Turn Authorization Logic into SQL
by SahAssar on Wednesday November 24, 2021 @11:52AM
(#29332041)
IIRC postgrest starts a transaction for each request, and inside of that sets the variables. I've done some testing to make sure that variables do not leak between requests.
See the local option here for more options: https://www.postgresql.org/docs/current/functions-admin.html...
If using the role-mapping feature of postgrest it works similarly, only setting the ROLE instead of the variables.