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.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers