BUG #13647: Error after upgrade 9.3->9.4: materialized view `foo` has not been populated

From: beni(at)strivewire(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13647: Error after upgrade 9.3->9.4: materialized view `foo` has not been populated
Date: 2015-09-28 09:08:04
Message-ID: 20150928090804.1426.34235@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13647
Logged by: Benjamin Flesch
Email address: beni(at)strivewire(dot)com
PostgreSQL version: 9.4.4
Operating system: Ubuntu 14.04
Description:

After upgrading using the ubuntu up_upgradecluser script, the materialized
views are not populated, resulting in errors.

I had to manually perform "REFRESH MATERIALIZED VIEW foo;" in order to fix
this issue.

It would be nice if the upgrade script also refreshed materialized views in
the future.

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-09-28 13:38:37 Re: BUG #13646: Upgrading existing db from 9.2 to 9.4.4 not working using postgresql-setup.
Previous Message jwhiting 2015-09-28 08:18:35 BUG #13646: Upgrading existing db from 9.2 to 9.4.4 not working using postgresql-setup.