Changing pg_attribute.attislocal - Mailing list pgsql-general

From Noah Misch
Subject Changing pg_attribute.attislocal
Date
Msg-id 20100722224139.GA9501@tornado.leadboat.com
Whole thread Raw
List pgsql-general
Over time, I mistakenly did something like this:

CREATE TABLE a ();
CREATE TABLE b () INHERITS(a);
ALTER TABLE b ADD col int;
ALTER TABLE a ADD col int;

where I should have left out the third statement.  Not a great loss, the only
consequence I've observed being pg_attribute.attislocal = true, so dropping
a.col will not drop b.col.  Is there a DDL way to change that, short of dropping
the column from both tables and re-adding it to the parent alone?  If not,
what's the danger of updating attislocal directly?  If it makes any difference,
I don't actually plan to drop the column anytime soon.

Thanks,
nm

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Question about SCO openserver and postgres...
Next
From: Andy Colson
Date:
Subject: Re: psql problem