| From: | Joe Van Dyk <joe(at)tanga(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | roles inheriting configuration values |
| Date: | 2014-02-07 19:08:02 |
| Message-ID: | CACfv+pKW5Fm=2xe-L4fB_OpgprNW=SP3y--qsn6jLvWj3mTJGw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Sacket | 2014-02-07 21:04:47 | Re: Ordering Results by a Supplied Order |
| Previous Message | Shaun Thomas | 2014-02-07 18:08:51 | Re: Better Connection Statistics |