>From documentation: "REFRESH MATERIALIZED VIEW completely replaces the contents of a materialized view. To execute this command you must be the owner of the materialized view." So it is intended behavior. https://www.postgresql.org/docs/11/sql-refreshmaterializedview.html ________________________________________ Från: Adrian Klaver [adrian.klaver@xxxxxxxxxxx] 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@xxxxxxxxxxx > <mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx
