Re: BUG #13907: Restore materialized view throw permission denied

On Tue, Jul 26, 2016 at 12:32 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> It's possible that the most reasonable fix is to move matview refreshes to
> after the ACL restoration step.  That would wreak a lot of havoc with
> the current view of a dump as being tripartite (pre-data/data/post-data),
> so it might be more work than we want to do.  But it seems like the
> logically soundest thing.

That is exactly what the patch I posted yesterday does.  Peter was
suggesting that wasn't good enough and that we should "split up the
ACL restores into the general part, which you would run right after
the object is restored, and the owner revokes, which you would run
last."  I guess the idea is that we would refresh the matviews in
between those two phases.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company