Re: Add --{no-,}bypassrls flags to createuser
Shinya Kato <shinya11.kato@oss.nttdata.com>
From: Shinya Kato <Shinya11.Kato@oss.nttdata.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Nathan Bossart <nathandbossart@gmail.com>, Przemysław Sztoch <przemyslaw@sztoch.pl>, "David G. Johnston" <david.g.johnston@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Daniel Gustafsson <daniel@yesql.se>, pgsql-hackers@postgresql.org
Date: 2022-05-23T14:55:43Z
Lists: pgsql-hackers
Attachments
- v7-0001-Add-missing-options-to-createuser.patch (text/x-diff) patch v7-0001
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
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Fix output of createuser --help with --valid-until
- 4ca998595788 16.0 landed
-
createuser: Add support for more clause types through new options
- 08951a7c93cf 16.0 landed
-
createuser: Cleanup and fix internal option ordering
- 50e4c280f066 16.0 landed
-
Add REPLICATION privilege for ROLEs
- 9b8aff8c192e 9.1.0 cited