Postgres Pro
Downloads
Home   >   mailing lists

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

From miha.vrhovnik@cordia.si
Subject BUG #13963: pg_clusterupgrade and materialized view
Date
Msg-id 20160216091311.2603.27097@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13963: pg_clusterupgrade and materialized view  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
Tree view 
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.

Regards,
Miha

pgsql-bugs by date:

Previous
From: Tom Puckett
Date:
Subject: aparent bug with pgAdmin version 1.22.1 connected to pg 9.5: SQL Pane view of SEQUENCE object
Next
From: Bruce Momjian
Date:
Subject: Re: Encoding problems with "COMMENT ON DATABASE .." causing pg_restore (and pg_upgrade) to fail