Re: BUG #9923: "reassign owned" does not change permissions grantor

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Alexey Bashtanov <bashtanov@imap.cc>
Cc: pgsql-bugs@postgresql.org
Date: 2015-01-22T17:37:56Z
Lists: 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. +


Commits

  1. adjust ACL owners for REASSIGN and ALTER OWNER TO