Re: BUG #12088: pg_upgrade 9.3 -> 9.4rc1 - implicit cast not ported

Hi,
I've tried to perform pg_dump with 9.3 binaries but I simply get no errors
and cast are not part of the dump...
So are not restored... How can I continue the investigation?

2014-12-05 13:19 GMT+01:00 Bruce Momjian <bruce(at)momjian(dot)us>:

> On Fri, Nov 28, 2014 at 08:28:16AM +0000, ing(dot)marco(dot)colombo(at)gmail(dot)com
> wrote:
> > The following bug has been logged on the website:
> >
> > Bug reference: 12088
> > Logged by: Marco Colombo
> > Email address: ing(dot)marco(dot)colombo(at)gmail(dot)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(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>

--
Ing. Marco Colombo