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)); >

[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