On Tue, Aug 13, 2019 at 08:28:12PM -0400, Stephen Frost wrote: > Getting it to be at check time would certainly be a great improvement. > > Solving this in pg_upgrade does seem like it's probably the better > approach rather than trying to do it in pg_dump. Unfortunately, that > likely means that all we can do is have pg_upgrade point out to the user > when something will fail, with recommendations on how to address it, but > that's also something users are likely used to and willing to accept, > and puts the onus on them to consider their ACL decisions when we're > making catalog changes, and it keeps these issues out of pg_dump.
Yeah, I think we just need to bite the bullet and create some infrastructure to help folks solve the problem. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +