roles inheriting configuration values

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: Raw Message | Whole Thread | 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)

Responses

Browse pgsql-general by date

  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