pg_upgrade (9.1 to 9.2) bombing on casts

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема pg_upgrade (9.1 to 9.2) bombing on casts
Дата
Msg-id CAOC+FBUPXxkwe+Qyx3e9_02h061L8OHgY4OUUtEFwwvYydbrig@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_upgrade (9.1 to 9.2) bombing on casts  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: pg_upgrade (9.1 to 9.2) bombing on casts  (Sergey Konoplev <gray.ru@gmail.com>)
Список 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@gmail.com

В списке pgsql-admin по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Couldn't start postgres, got no logging, ran postgres manually for info-- help?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_upgrade (9.1 to 9.2) bombing on casts