Re: add column .. default

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: add column .. default
Date: 2003-06-19 15:00:23
Message-ID: 8868.1056034823@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor <rbt(at)rbt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christian Plattner 2003-06-19 15:11:00 Access to transaction status
Previous Message Rod Taylor 2003-06-19 14:53:36 Re: add column .. default