pgsql: Avoid promising that "ADD COLUMN ... DEFAULT NULL" is free.

Started by Tom Laneover 12 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Avoid promising that "ADD COLUMN ... DEFAULT NULL" is free.

The system realizes that DEFAULT NULL is dummy in simple cases, but not if
a cast function (such as a length coercion) needs to be applied. It's
dubious that suppressing that function call would be appropriate, anyway.
For the moment, let's just adjust the docs to say that you should omit the
DEFAULT clause if you don't want a rewrite to happen. Per gripe from Amit
Langote.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/879808e5197c374e431e81fb5599dfea533bb9aa

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 12 ++++++++----
1 file changed, 8 insertions(+), 4 deletions(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers