Re: BUG #13963: pg_clusterupgrade and materialized view

On Tue, Feb 16, 2016 at 09:13:11AM +0000, miha.vrhovnik@cordia.si wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13963
> Logged by:          Miha
> Email address:      miha.vrhovnik@cordia.si
> PostgreSQL version: 9.5.1
> Operating system:   Ubuntu
> Description:
>
> Hey,
>
> I've just made a pg_clusterupgrade where the one database has a materialized
> view which is on another server, so the pg_fdw is used.. and this seems that
> was not updated during the pg_clusterupgrade
>
> It would be at least nice if pg_clusterupgrade would print out a notice if
> it cannot refresh the view.
>
> I haven't tested but maybe the problem is the same if one doesn't use
> materialized view via the pg_fdw.

Why do you think an upgrade should refresh a materialzied view?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +