I'd like to have join_collapse_limit=20 for all users that belong to a certain group. Is there a way to do that without having to alter all the roles that are in that group?
$ psql monkey
psql (9.3.1)
Type "help" for help.
monkey=# create user f1 login;
CREATE ROLE
monkey=# create user f2 in role f1 login;
CREATE ROLE
monkey=# alter role f1 set join_collapse_limit=20;
ALTER ROLE
$ psql --user f1 monkey
psql (9.3.1)
Type "help" for help.
monkey=> show join_collapse_limit ;
join_collapse_limit
---------------------
20
(1 row)
$ psql --user f2 monkey
psql (9.3.1)
Type "help" for help.
monkey=> show join_collapse_limit ;
join_collapse_limit
---------------------
8
(1 row)
