Re: Add --{no-,}bypassrls flags to createuser
David G. Johnston <david.g.johnston@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Shinya Kato <Shinya11.Kato@oss.nttdata.com>
Cc: Przemysław Sztoch <przemyslaw@sztoch.pl>, Nathan Bossart <nathandbossart@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Michael Paquier <michael@paquier.xyz>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Daniel Gustafsson <daniel@yesql.se>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2022-05-19T01:46:02Z
Lists: pgsql-hackers
On Wed, May 18, 2022 at 6:35 PM Shinya Kato <Shinya11.Kato@oss.nttdata.com> wrote: > > Too bad there's no --comment parameter to do COMMENT ON ROLE name IS > > 'Comment'; > > > > As you already make such changes in createuser, I would like to ask > > for an additional --comment parameter > > that will allow sysadmins to set a comment with additional information > > about the new DB user. > > psql is scary for some. :-) > > Since the createuser command is a wrapper for the CREATE ROLE command, I > do not think it is appropriate to add options that the CREATE ROLE > command does not have. > > I think that this feature is at least worth considering - but absent an existing command that does this I would agree that doing so constitutes a separate feature. As an aside, I'd rather overcome this particular objection by having the CREATE object command all accept an optional "COMMENT IS" clause. David J.
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