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
