Re: BUG #13179: pg_upgrade failure.

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: corey(dot)huinker(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13179: pg_upgrade failure.
Date: 2015-04-28 05:41:17
Message-ID: CAB7nPqTyOC1snkjxEvGBJQAKMyKbMck+Riw7KDu1nqh91fbEqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Apr 28, 2015 at 6:15 AM, <corey(dot)huinker(at)gmail(dot)com> wrote:
> 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.

What is the error you are seeing?

> 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.

Do you have a self-contained test case that could be used to reproduce
the failure?
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2015-04-28 06:23:52 Re: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Previous Message georgi-georgiev-pgsql 2015-04-28 01:56:47 BUG #13182: pgadmin3 not showing in application list