>> Also, I'm not yet convinced that simple privatizable transcient/session
>> variables would not be enough to fit the use case, [...]
> So... maybe? The main question then becomes how you integrate access control.
For what it's worth, permissions on persistent functions could be used to
control access to private-to-a-role transcient/session variables, see:
https://www.mail-archive.com/pgsql-hackers@postgresql.org/msg300651.html
The good point is that the implementation on top of session variables
would be trivial and very efficient, just prefix the variable with the
owner id in the key-value storage. The bad point is that there is no
full-featured GRANT on the variable itself, and it looks adhoc, somehow.
--
Fabien.