Re: document deviation from standard on REVOKE ROLE

On Fri, Oct 30, 2020 at 02:03:48PM -0400, John Naylor wrote:
> This is the other doc fix as suggested in 
> https://www.postgresql.org/message-id/20201027220555.GS4951%40momjian.us
>
> There is already a compatibility section, so put there.
> -- 
> John Naylor
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company 

> diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml
> index 35ff87a4f5..c8d5be92db 100644
> --- a/doc/src/sgml/ref/revoke.sgml
> +++ b/doc/src/sgml/ref/revoke.sgml
> @@ -298,6 +298,12 @@ REVOKE admins FROM joe;
> is required according to the standard, but <productname>PostgreSQL</productname>
> assumes <literal>RESTRICT</literal> by default.
> </para>
> +
> + <para>
> + In the SQL standard, <command>REVOKE</command> only revokes the privilege
> + as granted by the invoking role. In <productname>PostgreSQL</productname>,
> + this will also revoke privileges granted by other roles.
> + </para>
> </refsect1>
>
> <refsect1>

John, should this 2020 patch still be applied?

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.