RE: Happy column adding (was RE: [HACKERS] Happy column dropping) - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: Happy column adding (was RE: [HACKERS] Happy column dropping)
Date
Msg-id NDBBIJLOILGIKBGDINDFCEFHCCAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Happy column adding (was RE: [HACKERS] Happy column dropping)  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
Responses Re: Happy column adding (was RE: [HACKERS] Happy column dropping)
List pgsql-hackers
> -----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



pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: [HACKERS] Happy column dropping
Next
From: Don Baccus
Date:
Subject: Re: Happy column adding (was RE: [HACKERS] Happy column dropping)