| From: | Wells Oliver <wellsoliver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_upgrade (9.1 to 9.2) bombing on casts |
| Date: | 2013-07-12 04:55:14 |
| Message-ID: | CAOC+FBUPXxkwe+Qyx3e9_02h061L8OHgY4OUUtEFwwvYydbrig@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2013-07-12 05:09:39 | Re: pg_upgrade (9.1 to 9.2) bombing on casts |
| Previous Message | Wells Oliver | 2013-07-12 02:07:41 | Couldn't start postgres, got no logging, ran postgres manually for info-- help? |