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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Дата
Msg-id 20151217172937.GA2615@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Feike Steenbergen
Дата:
Сообщение: Re: BUG #13817: Query planner strange choose while select/count small part of big table - complete
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type