Difference options with the CREATE ROLE docs
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-creategroup.html
Description:
Hello,
This page says that "CREATE GROUP is now an alias for CREATE ROLE.",
But when u check the CREATE ROLE, u see they have different options,
I don't know if this is on purpose or not, But if it's just an alias, then
they should have the same options
If it's not the "exact same", then I guess there should be some explanations
about it
Thanks
On Fri, 10 Apr 2020 at 08:19, PG Doc comments form <noreply@postgresql.org>
wrote:
This page says that "CREATE GROUP is now an alias for CREATE ROLE.",
But when u check the CREATE ROLE, u see they have different options,
I don't know if this is on purpose or not, But if it's just an alias, then
they should have the same options
If it's not the "exact same", then I guess there should be some
explanations
about itIt seems an oversight. I'm attaching patches to fix it in all supported
branches. v11 can be applied cleanly to v12/master.
Regards,
--
Euler Taveira http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachments:
v10-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchtext/x-patch; charset=US-ASCII; name=v10-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchDownload+3-1
v95-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchtext/x-patch; charset=US-ASCII; name=v95-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchDownload+3-1
v96-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchtext/x-patch; charset=US-ASCII; name=v96-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchDownload+3-1
v11-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchtext/x-patch; charset=US-ASCII; name=v11-0001-Sync-CREATE-ROLE-and-CREATE-GROUP-synopsis.patchDownload+4-2
PG Doc comments form <noreply@postgresql.org> writes:
This page says that "CREATE GROUP is now an alias for CREATE ROLE.",
But when u check the CREATE ROLE, u see they have different options,
The implementations are the same, as you could easily find by experiment.
Looks like people have been sloppy about updating the manual page for
CREATE GROUP though :-(. Will fix, thanks for the report!
regards, tom lane
Euler Taveira <euler.taveira@2ndquadrant.com> writes:
It seems an oversight. I'm attaching patches to fix it in all supported
branches. v11 can be applied cleanly to v12/master.
Ah, I'd already done this before seeing your response :-(
regards, tom lane