Amit Langote <amitlangote09@gmail.com> writes:
> When I do the following:
> ALTER TABLE table ADD COLUMN numeric(x) DEFAULT NULL;
> The table is rewritten whereas notes section on the manual page for
> ALTER TABLE says otherwise (which holds true for most of the cases
> though).
Try it without the explicit DEFAULT clause.
Some experimentation suggests that we are smart about "DEFAULT NULL"
unless the column type requires a length-coercion cast, in which
case the default expression involves a function call, and that doesn't
get elided.
regards, tom lane