Horton

Re: pg_upgrade and materialized views

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Victor Yegorov <vyegorov@gmail.com>, Claudio Freire <klaussfreire@gmail.com>, pgsql-bugs@postgresql.org
Date: 2018-02-21T23:49:43Z
Lists: pgsql-bugs 
On 2018-02-21 18:45:26 -0500, Tom Lane wrote:
> I've pushed a fix for this.

Thanks for this work, the new comments indeed make this much
clearer!


Wonder if we should include a comment in the release notes that possible
occurances of the problem can be fixed with REFRESH? Perhaps that's
obvious?

I also wonder if there's a chance that this can result in wrong query
results without getting errors, once the xids appears to be from the
future - if so, should we ask people to refresh matviews if they're
older than pg_upgrade?

Greetings,

Andres Freund

Commits

  1. Repair pg_upgrade's failure to preserve relfrozenxid for matviews.