Re: docs: note ownership requirement for refreshing materializedviews

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: docs: note ownership requirement for refreshing materializedviews
Дата
Msg-id 20180816011534.GK3681@paquier.xyz
обсуждение исходный текст
Ответ на Re: docs: note ownership requirement for refreshing materializedviews  ("Jonathan S. Katz" <jonathan.katz@excoventures.com>)
Ответы Re: docs: note ownership requirement for refreshing materializedviews
Список pgsql-hackers
On Wed, Aug 15, 2018 at 09:06:34PM -0400, Jonathan S. Katz wrote:
> I played around with this feature a bit and did see this was the case.
> Also while playing around I noticed the error message was as such:
>
>     test=> REFRESH MATERIALIZED VIEW blah;
>     ERROR: must be owner of relation blah
>
> But it’s not a relation, it’s a materialized view. I attached a patch
> that I think should fix this. Kudos to Dave Cramer who was
> sitting next to me helping me to locate files and confirm assumptions.

A relation may be a materialized view, no?  The ACL check happens in
RangeVarCallbackOwnsTable by the way (look at ExecRefreshMatView in
matview.c).
--
Michael

Вложения

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

Предыдущее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: docs: note ownership requirement for refreshing materializedviews
Следующее
От: "Shinoda, Noriyoshi (PN Japan GCS Delivery)"
Дата:
Сообщение: Update comment in errcodes.txt correctly