Re: add column .. default - Mailing list pgsql-hackers

From Tom Lane
Subject Re: add column .. default
Date
Msg-id 8868.1056034823@sss.pgh.pa.us
Whole thread Raw
In response to Re: add column .. default  (Rod Taylor <rbt@rbt.ca>)
Responses Re: add column .. default  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Rod Taylor <rbt@rbt.ca> writes:
> Right now if the column exists in the child table, the add column is
> rejected.  I assume that will remain.

Have you actually tried it?

regression=# create table p1 (f1 int);
CREATE TABLE
regression=# create table c1 (f2 int) inherits(p1);
CREATE TABLE
regression=# alter table p1 add column f2 int;
NOTICE:  ALTER TABLE: merging definition of column "f2" for child c1
ALTER TABLE
regression=#
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: add column .. default
Next
From: "Christian Plattner"
Date:
Subject: Access to transaction status