Re: pg_upgrade (9.1 to 9.2) bombing on casts

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Wells Oliver <wellsoliver(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_upgrade (9.1 to 9.2) bombing on casts
Date: 2013-07-12 05:09:39
Message-ID: 20130712050939.GE29206@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Wells Oliver escribió:
> I have this error in a pg_upgrade:
>
> psql:pg_upgrade_dump_db.sql:88725: ERROR: UNION could not convert type
> text[] to integer[]

Have a look at the file and see what's in the mentioned line. My guess
is that this is a view definition, or similar, that no longer works.
This might be a bug in 9.2. Maybe share the definition here in case
someone can provide more detailed insight.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Giuseppe Broccolo 2013-07-12 09:23:35 Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help?
Previous Message Wells Oliver 2013-07-12 04:55:14 pg_upgrade (9.1 to 9.2) bombing on casts