SV: SV: Refreshing materialized views

2017-11-29 Thread Henrik Uggla
@lists.postgresql.org Ämne: Re: SV: Refreshing materialized views It may be simpler to just run the query from the materialized view definition as the user that you want to refresh the mv. On Tue, Nov 28, 2017 at 10:30 PM, Daevor The Devoted mailto:doll...@gmail.com>> wrote: On 28 Nov 2017 5:18 pm, &qu

Re: SV: Refreshing materialized views

2017-11-29 Thread Ben Primrose
It may be simpler to just run the query from the materialized view definition as the user that you want to refresh the mv. On Tue, Nov 28, 2017 at 10:30 PM, Daevor The Devoted wrote: > > > On 28 Nov 2017 5:18 pm, "Tom Lane" wrote: > > Henrik Uggla writes: > > The underlying tables are foreign

Re: SV: Refreshing materialized views

2017-11-28 Thread Daevor The Devoted
On 28 Nov 2017 5:18 pm, "Tom Lane" wrote: Henrik Uggla writes: > The underlying tables are foreign tables. The user has been mapped to a foreign user with select permission. I have no problem selecting from the foreign tables or the materialized views. [ shrug... ] WFM; if I can select from the

Re: SV: Refreshing materialized views

2017-11-28 Thread Tom Lane
Henrik Uggla writes: > The underlying tables are foreign tables. The user has been mapped to a > foreign user with select permission. I have no problem selecting from the > foreign tables or the materialized views. [ shrug... ] WFM; if I can select from the foreign table then I can make a mater

SV: Refreshing materialized views

2017-11-28 Thread Henrik Uggla
@lists.postgresql.org Ämne: Re: Refreshing materialized views Henrik Uggla writes: > I created some materialized views and set a group as owner. My problem is > that I can't refresh the views. I get "permission denied" even when using the > postgres super user. If

Re: Refreshing materialized views

2017-11-28 Thread Tom Lane
Henrik Uggla writes: > I created some materialized views and set a group as owner. My problem is > that I can't refresh the views. I get "permission denied" even when using the > postgres super user. If I change the owner to an ordinary user I still can't > refresh the view as the owner or post

Refreshing materialized views

2017-11-28 Thread Henrik Uggla
Hi I created some materialized views and set a group as owner. My problem is that I can't refresh the views. I get "permission denied" even when using the postgres super user. If I change the owner to an ordinary user I still can't refresh the view as the owner or postgres. Only if I change own