Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Alvaro Herrera <alvherre@2ndquadrant.com>
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: cpacejo@clearskydata.com
Cc: pgsql-bugs@postgresql.org, Robert Haas <robertmhaas@gmail.com>,
Kouhei Kaigai <kaigai@ak.jp.nec.com>
Date: 2015-12-17T17:29:37Z
Lists: pgsql-bugs
Alvaro Herrera wrote: > The commit msg says backpatched to 9.1, but given lack of backpatch of > another bugfix (commit 59367fdf9 for bug #9923) it doesn't actually > apply. I'd rather backpatch that fix and then apply this one. So I applied it to 9.5 and master only. If there are more votes for back-patching both changes to earlier branches, I can do so. I think we should do that -- in essence, this bug lets you corrupt your catalogs by dropping a user that still owns objects. I guess REASSIGN OWNED is not the most popular of commands. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
adjust ACL owners for REASSIGN and ALTER OWNER TO
- ab14c1383836 9.1.20 landed
- 7af3dd540e29 9.2.15 landed
- 62e6eba8d266 9.3.11 landed
- 2c8ae6442fed 9.4.6 landed
- 59367fdf97cc 9.5.0 cited