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

> -----Original Message-----
> From: Peter Eisentraut [mailto:e99re41(at)DoCS(dot)UU(dot)SE]
>
> 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.
>

IIRC,there were some reason that default for new column had been rejected.
It may be possible now.
Probably Tom knows it.

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp