Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade (9.1 to 9.2) bombing on casts - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: pg_upgrade (9.1 to 9.2) bombing on casts
Date
Msg-id 20130712050939.GE29206@eldon.alvh.no-ip.org
Whole thread Raw
In response to pg_upgrade (9.1 to 9.2) bombing on casts  (Wells Oliver <wellsoliver@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: pg_upgrade (9.1 to 9.2) bombing on casts
Next
From: Giuseppe Broccolo
Date:
Subject: Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help?