Skip site navigation (1) Skip section navigation (2)

Re: Typed-tables patch broke pg_upgrade

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Typed-tables patch broke pg_upgrade
Date: 2011-03-11 13:28:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Is this still an open bug?


Tom Lane wrote:
> I find that pg_upgrade fails in HEAD when asked to do a 9.1-to-9.1
> upgrade of the regression database.  It gets to this bit of the
> restore script:
> CREATE TABLE test_tbl2 OF public.test_type2;
> -- For binary upgrade, recreate dropped column.
> UPDATE pg_catalog.pg_attribute
> SET attlen = -1, attalign = 'i', attbyval = false
> WHERE attname = ''
>   AND attrelid = 'test_tbl2'::pg_catalog.regclass;
> and fails with 
> ERROR:  cannot drop column from typed table
> which probably is because test_type2 has a dropped column.
> Somebody has failed to think through something, because if this state of
> affairs was allowed to be created during the regression tests, why
> should we not be able to restore it?
> (pg_upgrade's ENUM support is broken too, but at least that one is a
> one-line fix.)
> 			regards, tom lane

  Bruce Momjian  <bruce(at)momjian(dot)us>

  + It's impossible for everything to be true. +

In response to


pgsql-hackers by date

Next:From: Fujii MasaoDate: 2011-03-11 13:29:44
Subject: Re: Replication server timeout patch
Previous:From: Fujii MasaoDate: 2011-03-11 13:21:52
Subject: Re: Sync Rep v19

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group