pg_upgrade (9.1 to 9.2) bombing on casts

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux