Re: Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

On Fri, May 23, 2014 at 06:28:28AM -0700, David G Johnston wrote:
> Bruce Momjian wrote
> > On Thu, May 22, 2014 at 09:20:38AM -0600, Jeff Ross wrote:
> >> >I just tested ALTER TABLE in 8.4 and it does create a toast table for
> >> >this case in 9.4:
> >> >
> >> > CREATE TABLE test (x CHAR(10));
> >> > ALTER TABLE test ALTER COLUMN x TYPE CHAR(8000);
> >> >
> >> I just tried this on the problem table and it did indeed create a
> >> toast table.
> >>
> >> I then retried pg_upgrade and it failed with the same problem on a
> >> different table in the same database. Of the 67 databases in the
> >> 8.4 cluster, 5 (so far) have had this problem on at least one table.
> >
> > Yeah, it would be nice to be able to report all the problem tables, but
> > I don't know how to do that except from pg_upgrade failing. Is there
> > anything similar about these tables?
>
> Would a toast table in this situation have to be empty on the 8.4 database?
> Is there some kind of stat table query that would identify all such toast
> tables? Although it is possible some of those tables do indeed need a toast
> table but never make use of it (especially if one makes judicious use of
> unlimited text columns but never fills them with large amounts of data -
> like for lookup tables).

I don't see that as helping here.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +