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

Shinya Kato <shinya11.kato@oss.nttdata.com>

From: Shinya Kato <Shinya11.Kato@oss.nttdata.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Michael Paquier <michael@paquier.xyz>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Daniel Gustafsson <daniel@yesql.se>, pgsql-hackers@postgresql.org
Date: 2022-04-28T06:06:30Z
Lists: pgsql-hackers

Attachments

Thank you for the reviews!

On 2022-04-26 05:19, Nathan Bossart wrote:

> -	printf(_("  -g, --role=ROLE           new role will be a member of 
> this role\n"));
> +	printf(_("  -g, --role=ROLE        new role will be a member of this 
> role\n"));
> This looks lik an unexpected change.

I fixed it.


>> I'm ok with -m/--member as well (like with --role only one role can be
>> specified per switch instance so member, not membership, the later 
>> meaning,
>> at least for me, the collective).
>> 
>> That -m doesn't match --role-to is no worse than -g not matching 
>> --role, a
>> short option seems worthwhile, and the -m (membership) mnemonic should 
>> be
>> simple to pick-up.
>> 
>> I don't see the addition of "-name" to the option name being 
>> beneficial.
>> 
>> Yes, the standard doesn't use the "TO" prefix for "ROLE" - but taking 
>> that
>> liberty for consistency here is very appealing and there isn't another 
>> SQL
>> clause that it would be confused with.
> 
> +1 for "member".  It might not be perfect, but IMO it's the clearest
> option.

Thanks! I changed the option "--membership" to "--member".


For now, I also think "-m / --member" is the best choice, although it is 
ambiguous:(
I'd like to hear others' opinions.

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 →
  1. Fix output of createuser --help with --valid-until

  2. createuser: Add support for more clause types through new options

  3. createuser: Cleanup and fix internal option ordering

  4. Add REPLICATION privilege for ROLEs