Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Date
Msg-id 10227.1450373793@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> 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 think Bruce did not backpatch 59367fdf9 for fear of
backwards-compatibility complaints, but I tend to agree that that decision
was mistaken.  The argument that you can be left with essentially corrupt
catalogs seems pretty strong.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #13681: Serialization failures caused by new multixact code of 9.3 (back-patch request)