]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 04e298b) | patch
Avoid promising that "ADD COLUMN ... DEFAULT NULL" is free.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 3 Apr 2014 16:38:00 +0000 (12:38 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 3 Apr 2014 16:38:00 +0000 (12:38 -0400)
commit879808e5197c374e431e81fb5599dfea533bb9aa
tree1d95e7adfbc178066b5dbc2d40c6f742a5b558c8tree | snapshot
parent04e298b826d452ceb838d9fda884a29f229d484dcommit | diff
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.
doc/src/sgml/ref/alter_table.sgml diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.