]> granicus.if.org Git - postgresql/commit
Doc: clarify when table rewrites happen with column addition and DEFAULT
authorMichael Paquier <michael@paquier.xyz>
Fri, 19 Jul 2019 02:43:11 +0000 (11:43 +0900)
committerMichael Paquier <michael@paquier.xyz>
Fri, 19 Jul 2019 02:43:11 +0000 (11:43 +0900)
commit80aa66392ec8264cad6b2ad1bb442238c8771a6d
tree2b4f925daa781cf2b52eb9513608a0d52ee21158
parent477ebfc9695e267d3f345a77211579236bcac91c
Doc: clarify when table rewrites happen with column addition and DEFAULT

16828d5 has improved ALTER TABLE so as a column addition does not
require a rewrite for a non-NULL default with constant expressions, but
one spot in the documentation did not get updated consistently.
The documentation also now clarifies the fact that this does not apply
if the expression is volatile, where a table rewrite is still required.

Reported-by: Daniel Westermann
Author: Ian Barwick
Reviewed-by: Michael Paquier, Daniel Westermann
Discussion: https://postgr.es/m/DB6PR0902MB2184C7D5645CF15D75EB7957D2CF0@DB6PR0902MB2184.eurprd09.prod.outlook.com
Backpatch-through: 11
doc/src/sgml/ddl.sgml