Amit Langote <amitlangote09@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
