Re: AW: [HACKERS] ALTER TABLE DROP COLUMN

[Chris]

Hiroshi Inoue wrote:

> Certainly it would need 2x.
> However is ADD COLUMN DEFAULT really needed ?
> I would do as follows.
> 
>     ADD COLUMN (without default)
>     UPDATE .. SET new_column = new default
>     ALTER TABLE ALTER COLUMN SET DEFAULT

Well in current postgres that would use 2x. With WAL I presume that
would use a lot of log space and probably a lot more processing. But if
you can do the above you might as well support the right syntax.