Postgres Pro
Downloads
Home   >   mailing lists

Re: accessing cross-schema materialized views - Mailing list pgsql-general

From Rob Sargent
Subject Re: accessing cross-schema materialized views
Date
Msg-id 841410d9-1221-e2cb-0de4-dfb36f6d1de7@gmail.com
Whole thread Raw
In response to accessing cross-schema materialized views  (Tim Clarke <tim.clarke@minerva.info>)
List pgsql-general
Tree view
On 3/31/21 4:31 PM, Tim Clarke wrote:

We have:

    create materialized view schema1.matview.....
    grant select on table schema1.matview to mygroup

    create view schema2.usingview as select ... from schema1.matview
    grant select on table schema2.using to mygroup

Is that schema2.using just a typo (phony names)?

pgsql-general by date:

Previous
From: Tim Clarke
Date:
Subject: accessing cross-schema materialized views
Next
From: Tom Lane
Date:
Subject: Re: accessing cross-schema materialized views