On Fri, May 23, 2014 at 08:32:35AM -0600, Jeff Ross wrote: > > On 5/23/14, 7:21 AM, 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? > > > > > Here are the last 2 tables I had a problem with:
Both have character varying fields, which supports the idea that the field length might have been modified in pg_attribute. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
