Re: Permission to refresh materialized view - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Permission to refresh materialized view
Date
Msg-id 697e7b56-a3c3-d467-735e-be66a44ba8e8@aklaver.com
Whole thread Raw
In response to Permission to refresh materialized view  (Johann Spies <johann.spies@gmail.com>)
Responses SV: Permission to refresh materialized view  (Gustavsson Mikael <mikael.gustavsson@smhi.se>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance of ByteA: ascii vs binary
Next
From: Thomas Güttler
Date:
Subject: minio server. Was: Performance of ByteA: ascii vs binary