Re: CREATEROLE and role ownership hierarchies

On 2021-10-29 01:14, Tom Lane wrote:
> Mark Dilger <mark.dilger@enterprisedb.com> writes:
>> The only intentional backward compatibility break in this patch set is 
>> the the behavior of CREATEROLE.  The general hope is that such a 
>> compatibility break will help far more than it hurts, as CREATEROLE 
>> does not appear to be a well adopted feature.  I would expect that 
>> breaking the behavior of the WITH ADMIN OPTION feature would cause a 
>> lot more pain.
> 
> Even more to the point, WITH ADMIN OPTION is defined by the SQL 
> standard.
> The only way you get to mess with that is if you can convince people we
> mis-implemented the standard.
Thank you for the detailed explanation.
I now understand what you said.

-- 
Regards,

--
Shinya Kato
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION