Happy column adding (was RE: [HACKERS] Happy column dropping) - Mailing list 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