Changing pg_attribute.attislocal

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Changing pg_attribute.attislocal
Date: 2010-07-22 22:41:39
Message-ID: 20100722224139.GA9501@tornado.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-07-23 01:02:40 Re: psql problem
Previous Message Scott Marlowe 2010-07-22 22:39:22 Re: Question about SCO openserver and postgres...