Typed-tables patch broke pg_upgrade
От | Tom Lane |
---|---|
Тема | Typed-tables patch broke pg_upgrade |
Дата | |
Msg-id | 11842.1297295013@sss.pgh.pa.us обсуждение исходный текст |
Ответы |
Re: Typed-tables patch broke pg_upgrade
Re: Typed-tables patch broke pg_upgrade Re: Typed-tables patch broke pg_upgrade |
Список | pgsql-hackers |
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 = '........pg.dropped.2........' AND attrelid = 'test_tbl2'::pg_catalog.regclass; ALTER TABLE ONLY test_tbl2 DROP COLUMN "........pg.dropped.2........"; 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
В списке pgsql-hackers по дате отправления: