Re: Role inheritance and Conflicting Parameter Values

"McGehee, Robert" <Robert(dot)McGehee(at)geodecapital(dot)com> writes:
> I'm trying to set the default statement_timeout parameter for two different groups of users. However, as many of the users inherit from overlapping roles, I wanted to get clarification on how inheritance of parameter values worked when a role inherits from other roles that all have different settings for a parameter value.

I'm pretty sure there is no inheritance for ALTER ROLE SET parameters.
Role inheritance only applies to grantable permissions.

> Also, as a superuser, can I examine the parameter values for another
> user to make sure I set this correctly.

You can certainly look at the pg_db_role_setting catalog to find this out.
I don't remember offhand if there are any system views that present the
information in a more friendly fashion.

regards, tom lane