I have this error in a pg_upgrade:
psql:pg_upgrade_dump_db.sql:88725: ERROR: UNION could not convert type
text[] to integer[]
Command executed:
time \
/usr/lib/postgresql/9.2/bin/pg_upgrade -k \
-b /usr/lib/postgresql/9.1/bin \
-B /usr/lib/postgresql/9.2/bin \
-d /data/postgresql/9.1/test \
-D /data/postgresql/9.2/main \
-o '-D /etc/postgresql/9.1/test' \
-O '-D /etc/postgresql/9.2/main'
In a view using that sort of cast. I thought maybe pg_upgrade would be able
to handle any custom casts.. Is there some way of fixing this without
removing the offending view?
--
Wells Oliver
wellsoliver(at)gmail(dot)com