Re: BUG #9923: "reassign owned" does not change permissions grantor - Mailing list pgsql-bugs

On Fri, Jan  9, 2015 at 01:19:48PM -0500, Bruce Momjian wrote:
> I can confirm this bug report from April, and your analysis of the fixes
> --- we were missing calls to aclnewowner() for types, foreign servers,
> and foreign data wrappers, for both REASSIGN and ALTER OWNER TO.
>
> With the attached SQL script you can see the ACL fields properly
> changing to match the object owner (attached).  Without the patch, only
> the table's ACL changes.
>
> The patch also changes the regression output --- I think that is because
> the object ownership changes remove certain duplicates from the ACL
> list.

Patch applied.  Thank you for the excellent bug report.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +