Horton

Re: pg_upgrade and materialized views

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Victor Yegorov <vyegorov@gmail.com>
Cc: Claudio Freire <klaussfreire@gmail.com>, pgsql-bugs@postgresql.org
Date: 2018-02-21T15:08:12Z
Lists: pgsql-bugs 
Victor Yegorov <vyegorov@gmail.com> writes:
> Is it possible, that bug #14852 is of the same nature as the issue at hand
> here?
> https://postg.es/m/20171013115320.28049.86457@wrigleys.postgresql.org

For the archives' sake, the correct link is
https://www.postgresql.org/message-id/20171013115320.28049.86457@wrigleys.postgresql.org

Yeah, that does look suspiciously like a set of facts matching this
problem :-(

			regards, tom lane

Commits

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