Re: [PATCH] Conflation of member/privs for predefined roles

2021-10-27 Thread Joshua Brindle
On Wed, Oct 27, 2021 at 1:34 PM Bossart, Nathan wrote: > > On 10/27/21, 10:28 AM, "Joshua Brindle" > wrote: > > I'm new to contributing here but I've been told that the string > > changes get taken care of later, is that not true? > > I will sometimes leave out tests and docs until I get buy-in

Re: [PATCH] Conflation of member/privs for predefined roles

2021-10-27 Thread Bossart, Nathan
On 10/27/21, 10:28 AM, "Joshua Brindle" wrote: > I'm new to contributing here but I've been told that the string > changes get taken care of later, is that not true? I will sometimes leave out tests and docs until I get buy-in on the approach. But for serious consideration, I think the patch has

Re: [PATCH] Conflation of member/privs for predefined roles

2021-10-27 Thread Joshua Brindle
On Wed, Oct 27, 2021 at 1:20 PM Bossart, Nathan wrote: > > On 10/26/21, 3:50 PM, "Joshua Brindle" wrote: > > Generally if a role is granted membership to another role with NOINHERIT > > they must use SET ROLE to access the privileges of that role, however > > with predefined roles the membership

Re: [PATCH] Conflation of member/privs for predefined roles

2021-10-27 Thread Bossart, Nathan
On 10/26/21, 3:50 PM, "Joshua Brindle" wrote: > Generally if a role is granted membership to another role with NOINHERIT > they must use SET ROLE to access the privileges of that role, however > with predefined roles the membership and privilege is conflated, as > demonstrated by: I think it make

[PATCH] Conflation of member/privs for predefined roles

2021-10-26 Thread Joshua Brindle
Generally if a role is granted membership to another role with NOINHERIT they must use SET ROLE to access the privileges of that role, however with predefined roles the membership and privilege is conflated, as demonstrated by: CREATE ROLE readrole; CREATE ROLE role2 NOINHERIT; CREATE ROLE brindle