> -----Original Message-----
> From: Peter Eisentraut [mailto:e99re41@DoCS.UU.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@tpf.co.jp