Horton

Thread

Commits

  1. Doc: sync CREATE GROUP syntax synopsis with CREATE ROLE.

  1. Difference options with the CREATE ROLE docs

    The Post Office <noreply@postgresql.org> — 2020-04-10T00:26:01Z

    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

  2. Re: Difference options with the CREATE ROLE docs

    Euler Taveira <euler.taveira@2ndquadrant.com> — 2020-04-10T13:58:58Z

    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 it
>
> It 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

  3. Re: Difference options with the CREATE ROLE docs

    Tom Lane <tgl@sss.pgh.pa.us> — 2020-04-10T14:15:46Z

    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

  4. Re: Difference options with the CREATE ROLE docs

    Tom Lane <tgl@sss.pgh.pa.us> — 2020-04-10T15:08:13Z

    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