createuser --memeber and PG 16
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2023-05-10T17:33:26Z
Lists: pgsql-hackers
Attachments
- role.diff (text/x-diff) patch
In writing the PG 16 release notes, I came upon an oddity in our new createuser syntax, specifically --role and --member. It turns out that --role matches CREATE ROLE ... ROLE IN (and has prior to PG 16) while the new --member option matches CREATE ROLE ... ROLE. The PG 16 feature discussion thread is here: https://www.postgresql.org/message-id/flat/69a9851035cf0f0477bcc5d742b031a3%40oss.nttdata.com This seems like it will be forever confusing to people. I frankly don't know why --role matching CREATE ROLE ... ROLE IN was not already confusing in pre-PG 16. Any new ideas for improvement? At a minium I would like to apply the attached doc patch to PG 16 to improve awkward wording in CREATE ROLE and createuser. -- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you human, rather than perfect, which you will never be.
Commits
-
Document deprecated createuser option.
- 381d19b3ea0e 16.0 landed
-
Rename some createuser options.
- 2dcd1578c401 16.0 landed
-
doc: improve description of adding roles as members
- ce3673daded3 16.0 landed
-
Mark options as deprecated in usage output
- 2f80c95740f8 16.0 cited