| From: | corey(dot)huinker(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #13179: pg_upgrade failure. |
| Date: | 2015-04-27 21:15:55 |
| Message-ID: | 20150427211555.2546.8955@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: 13179
Logged by: Corey Huinker
Email address: corey(dot)huinker(at)gmail(dot)com
PostgreSQL version: 9.3.6
Operating system: Ubuntu 14.04
Description:
I am experiencing a pg_upgrade failure 9.3->9.4, that seems to be the same
root cause as BUG #12465: Materialized view dump restoration issue.
I have a SQL immutable function created in the public schema, which returns
a custom enum type that also resides in the public schema. The type is
created correctly, and the function is created correctly.
However, that function is called via a CROSS LATERAL JOIN inside a
materialized view which is in a different schema. The restoration of that
materialized view fails.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-04-27 22:22:37 | Re: [SPAM] Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot |
| Previous Message | David Gould | 2015-04-27 20:11:46 | Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated) |