Re: Add --{no-,}bypassrls flags to createuser

From: Shinya Kato <Shinya11(dot)Kato(at)oss(dot)nttdata(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Nathan Bossart <nathandbossart(at)gmail(dot)com>, Przemysław Sztoch <przemyslaw(at)sztoch(dot)pl>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add --{no-,}bypassrls flags to createuser
Date: 2022-05-23 14:55:43
Message-ID: e2659356769a778308bd3e18732ceeb2@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2022-05-23 16:29, Michael Paquier wrote:
>> +$node->issues_sql_like(
>> + [ 'createuser', 'regress_role2', '-a', 'regress_user1' ],
>> + qr/statement: CREATE ROLE regress_role2 NOSUPERUSER NOCREATEDB
>> NOCREATEROLE INHERIT LOGIN ADMIN regress_user1;/,
>> + 'add a role as a member with admin option of the newly created
>> role');
>> +$node->issues_sql_like(
>> + [ 'createuser', 'regress_role3', '-m', 'regress_user1' ],
>> + qr/statement: CREATE ROLE regress_role3 NOSUPERUSER NOCREATEDB
>> NOCREATEROLE INHERIT LOGIN ROLE regress_user1;/,
>> + 'add a role as a member of the newly created role');
>
> May I ask for the addition of tests when one specifies multiple
> switches for --admin and --member? This would check the code path
> where you build a list of role names. You could check fancier string
> patterns, while on it, to look after the use of fmtId(), say with
> role names that include whitespaces or such.

Thanks!
I changed to the test that describes multiple "-m".
It seems to be working without any problems, how about it?

--
Regards,

--
Shinya Kato
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

Attachment Content-Type Size
v7-0001-Add-missing-options-to-createuser.patch text/x-diff 10.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Geier 2022-05-23 15:31:16 Re: WIP Patch: Precalculate stable functions, infrastructure v1
Previous Message Tom Lane 2022-05-23 14:08:54 Re: Enforce "max_wal_size/ min_wal_size must be at least twice wal_segment_size" limit while setting GUCs