Josh Berkus <josh(at)agliodbs(dot)com> writes:
> What I want to be able to do is to set different bunches of resource
> management settings for various non-login inherited roles, and be able
> to choose profiles via a SET ROLE. The reason to do this, btw, instead
> of defining various login roles, is that different login roles can't
> share the same connection pool.
The question is why this should be tied to SET ROLE, which already has
well defined semantics that don't include any such behavior.
regards, tom lane