[HACKERS] Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-23 Thread David G Johnston
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

Re: [HACKERS] Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-23 Thread Bruce Momjian
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