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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.