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)
