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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: BUG #9923: "reassign owned" does not change permissions grantor
Дата
Msg-id 20150122173756.GG27749@momjian.us
обсуждение исходный текст
Ответ на Re: BUG #9923: "reassign owned" does not change permissions grantor  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: BUG #9923: "reassign owned" does not change permissions grantor  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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. +

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade failure on Windows Server
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success.