From documentation:
"REFRESH MATERIALIZED VIEW completely replaces the contents of a materialized view. To execute this command you must be
theowner of the materialized view."
So it is intended behavior.
https://www.postgresql.org/docs/11/sql-refreshmaterializedview.html
________________________________________
Från: Adrian Klaver [adrian.klaver@aklaver.com]
Skickat: den 18 mars 2019 15:51
Till: Johann Spies
Kopia: pgsql-general
Ämne: Re: Permission to refresh materialized view
On 3/17/19 11:52 PM, Johann Spies wrote:
Please reply to list also.
Ccing list.
>
>
> On Wed, 13 Mar 2019 at 16:24, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 3/13/19 6:27 AM, Johann Spies wrote:
> ...
> > But user Y gets the message that he has to be the owner of a
> > materialized view to be able to refresh it.
>
> What is the exact message?
>
>
> [42501] ERROR: must be owner of materialized view xxx_mv
>
> Regards
> Johann
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you. (Psalm 63:3)
--
Adrian Klaver
adrian.klaver@aklaver.com