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