Re: Permission to refresh materialized view

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Johann Spies <johann(dot)spies(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permission to refresh materialized view
Date: 2019-03-18 14:51:01
Message-ID: 697e7b56-a3c3-d467-735e-be66a44ba8e8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Güttler 2019-03-18 14:59:58 minio server. Was: Performance of ByteA: ascii vs binary
Previous Message Tom Lane 2019-03-18 14:49:45 Re: Performance of ByteA: ascii vs binary