Re: docs: note ownership requirement for refreshing materializedviews

Поиск
Список
Период
Сортировка
От Jonathan S. Katz
Тема Re: docs: note ownership requirement for refreshing materializedviews
Дата
Msg-id 55498B5B-0155-4B0E-9B97-23167F8CB380@excoventures.com
обсуждение исходный текст
Ответ на docs: note ownership requirement for refreshing materialized views  (Dian Fay <dian.m.fay@gmail.com>)
Ответы Re: docs: note ownership requirement for refreshing materializedviews
Список pgsql-hackers
Hi Dian,

> On Aug 15, 2018, at 7:46 PM, Dian Fay <dian.m.fay@gmail.com> wrote:
>
> hi all! I discovered today that the REFRESH MATERIALIZED VIEW documentation doesn't mention that only the owner (or a
superuser)may actually perform the refresh operation. This patch adds a note to that effect. 

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.

Jonathan


Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: xact_start meaning when dealing with procedures?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: docs: note ownership requirement for refreshing materializedviews