Re: BUG #13963: pg_clusterupgrade and materialized view - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #13963: pg_clusterupgrade and materialized view
Date
Msg-id 20160218025253.GB26716@momjian.us
Whole thread Raw
In response to BUG #13963: pg_clusterupgrade and materialized view  (miha.vrhovnik@cordia.si)
List pgsql-bugs
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                             +

pgsql-bugs by date:

Previous
From: Venkata Balaji N
Date:
Subject: Re: BUG #13962: transaction logs growing on standby
Next
From: Bruce Momjian
Date:
Subject: Re: aparent bug with pgAdmin version 1.22.1 connected to pg 9.5: SQL Pane view of SEQUENCE object