Refreshing materialized views - Mailing list pgsql-general

From Henrik Uggla
Subject Refreshing materialized views
Date
Msg-id 9240031180ff4c419251652f39908dd0@kristianstad.se
Whole thread Raw
Responses Re: Refreshing materialized views
List pgsql-general
Hi

I created some materialized views and set a group as owner. My problem is that I can't refresh the views. I get
"permissiondenied" even when using the postgres super user. If I change the owner to an ordinary user I still can't
refreshthe view as the owner or postgres. Only if I change owner to postgres am I able to refresh the view, but only as
thepostgres user. I've mainly tried with Pgadmin4 but also a few times with psql, and the database is installed as a
dockercontainer. Please help. 

cheers
HU

pgsql-general by date:

Previous
From: Robert Haas
Date:
Subject: Re: ERROR: too many dynamic shared memory segments
Next
From: Tom Lane
Date:
Subject: Re: vacuumdb fails with error pg_statistic_relid_att_inh_index constraint violation after upgrade to 9.6