On Thu, Apr 3, 2014 at 12:54 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > 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. > Thanks, that does the trick. > 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. > Is there a warning about such behavior in the manual? Is it useful to include it somewhere (not sure where though)? -- Amit -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
