Re: Typed-tables patch broke pg_upgrade - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Typed-tables patch broke pg_upgrade
Date
Msg-id 1301503812.31317.1.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Typed-tables patch broke pg_upgrade  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Typed-tables patch broke pg_upgrade
Re: Typed-tables patch broke pg_upgrade
List pgsql-hackers
On tor, 2011-02-10 at 06:31 +0200, Peter Eisentraut wrote:
> > ERROR:  cannot drop column from typed table
> >
> > which probably is because test_type2 has a dropped column.
>
> It should call
>
> ALTER TYPE test_type2 DROP ATTRIBUTE xyz CASCADE;
>
> instead.  That will propagate to the table.

Here is a patch that addresses this problem.

It looks like Noah Misch might have found another problem in this area.
We'll have to investigate that.

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Problem with pg_upgrade?
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_dump --binary-upgrade vs. ALTER TYPE ... DROP ATTRIBUTE