@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
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
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
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
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.
This is the error in the log (not very useful):
2017-11-28 13:58:03.207 UTC [347] STATEMENT: REFRESH MATERI
