Re: confusing terms

2018-09-07 Thread Bruce Momjian
On Mon, Sep  3, 2018 at 07:17:12AM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/10/static/role-membership.html
> Description:
> 
> https://www.postgresql.org/docs/10/static/role-membership.html
> 
> it says
> 
> "Once the group role exists, you can add and remove members using the GRANT
> and REVOKE commands:
> 
> GRANT group_role TO role1, ... ;
> REVOKE group_role FROM role1, ... ;"
> 
> how can you add members to a newly created group role using the above
> command? shouldn't it be GRANT group_role TO user1 ??

Well, users and groups are both roles.  The sentence says below this:

   You can grant membership to other group roles, too (since there isn't
   really any distinction between group roles and non-group roles). 

meaning you can grant group role membership to user and other group
roles.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+  Ancient Roman grave inscription +



link to Slow_Query_Questions from wiki/Main Page

2018-09-07 Thread Justin Pryzby
Hi,

I'm suggesting to link to:
https://wiki.postgresql.org/wiki/Slow_Query_Questions

>From either:
https://wiki.postgresql.org/wiki/Main%20Page
or:
https://wiki.postgresql.org/wiki/Performance_Optimization

I know it's a wiki, but it looks like I'm not allowed to edit the 'Main' page,
so I'm asking here, which is prolly for the best anyway.  Feel free to forward
to or ask for opinion on the -perform list.

Thanks,
Justin