Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: cpacejo(at)clearskydata(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>, Kouhei Kaigai <kaigai(at)ak(dot)jp(dot)nec(dot)com>
Subject: Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Date: 2015-12-17 17:29:37
Message-ID: 20151217172937.GA2615@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-12-17 17:36:33 Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Previous Message Millepied, Pascal (GE Healthcare) 2015-12-17 16:30:31 Known issues on PostgreSQL server 8.1.19