Re: pg_upgrade (9.1 to 9.2) bombing on casts

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