Amit Langote <amitlangot...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
