Re: CREATEROLE and role ownership hierarchies - Mailing list pgsql-hackers

From Shinya Kato
Subject Re: CREATEROLE and role ownership hierarchies
Date
Msg-id 0bedda530a5b6c39a0e25359cea2e247@oss.nttdata.com
Whole thread Raw
In response to Re: CREATEROLE and role ownership hierarchies  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: TAP test for recovery_end_command
Next
From: Greg Nancarrow
Date:
Subject: Re: Added schema level support for publication.