Re: BUG #12088: pg_upgrade 9.3 -> 9.4rc1 - implicit cast not ported - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #12088: pg_upgrade 9.3 -> 9.4rc1 - implicit cast not ported
Date
Msg-id 20141205121927.GH31531@momjian.us
Whole thread Raw
In response to BUG #12088: pg_upgrade 9.3 -> 9.4rc1 - implicit cast not ported  (ing.marco.colombo@gmail.com)
Responses Re: BUG #12088: pg_upgrade 9.3 -> 9.4rc1 - implicit cast not ported
List pgsql-bugs
On Fri, Nov 28, 2014 at 08:28:16AM +0000, ing.marco.colombo@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      12088
> Logged by:          Marco Colombo
> Email address:      ing.marco.colombo@gmail.com
> PostgreSQL version: 9.4beta2
> Operating system:   Centos 7 64bit
> Description:
>
> Hi, we have defined some implicit cast in the schema. After pg_upgrade
> process, these have been dropped and we had to create them again.
>
> Cast are defined as:
>
> create cast (varchar as numeric) with inout as implicit;
>
> create cast (unknown as numeric) with inout as implicit;
>
> create cast (unknown as text) with inout as implicit;
>
> create cast (unknown as integer) with inout as implicit;

Well, pg_ugprade uses pg_dump to restore objects so I suggest you look
at the pg_dump output of 9.3 to see why they were not output.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

pgsql-bugs by date:

Previous
From: Preeti Karadi
Date:
Subject: Re: BUG #12141: PostgreSQL cannot be started
Next
From: John R Pierce
Date:
Subject: Re: BUG #12141: PostgreSQL cannot be started