Happy column adding (was RE: [HACKERS] Happy column dropping)

Peter Eisentraut <e99re41@docs.uu.se>

From: Peter Eisentraut <e99re41@DoCS.UU.SE>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-01-25T10:55:23Z
Lists: pgsql-hackers
On Tue, 25 Jan 2000, Hiroshi Inoue wrote:

> Even default is not allowed in ADD COLUMN now. 
> There may be other reasons why they aren't allowed.

It's not a matter of *allowed*, it's a parsing deficiency. The fact that
there was a default declared gets silently ignored. If y'all allow ;) I
would like to fix that (have already started a bit) by perusing the code
in parse_func.c:transformCreateStmt and do the same for the alter table
add column part. Maybe and add/drop constraint will come out in the end as
well.

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden