Re: pg_upgrade and materialized views

Claudio Freire <klaussfreire@gmail.com>

From: Claudio Freire <klaussfreire@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>, Victor Yegorov <vyegorov@gmail.com>, pgsql-bugs@postgresql.org
Date: 2018-02-22T11:27:11Z
Lists: pgsql-bugs
On Wed, Feb 21, 2018 at 8:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andres Freund <andres@anarazel.de> writes:
>> On 2018-02-21 10:08:12 -0500, Tom Lane wrote:
>>> Yeah, that does look suspiciously like a set of facts matching this
>>> problem :-(
>
>> I'd personally say ;), given that it's one less potentially data
>> corrupting bug to worry about ;). And it's one that can be fixed without
>> dataloss to boot.
>
> I've pushed a fix for this.

Thanks for addressing this so quickly :-)


Commits

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