Refreshing materialized views

Поиск
Список
Период
Сортировка
От Henrik Uggla
Тема Refreshing materialized views
Дата
Msg-id 9240031180ff4c419251652f39908dd0@kristianstad.se
обсуждение исходный текст
Ответы Re: Refreshing materialized views
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: ERROR: too many dynamic shared memory segments
Следующее
От: Tom Lane
Дата:
Сообщение: Re: vacuumdb fails with error pg_statistic_relid_att_inh_index constraint violation after upgrade to 9.6