]> granicus.if.org Git - postgresql/commit
Fix table rewrites that include a column without a default.
authorAndres Freund <andres@anarazel.de>
Thu, 10 Oct 2019 05:00:50 +0000 (22:00 -0700)
committerAndres Freund <andres@anarazel.de>
Thu, 10 Oct 2019 05:00:50 +0000 (22:00 -0700)
commit93765bd956bea26206043de8cbb0ae4b67e4df15
tree41aad2f3c03176d3f43c78e65b4a0c2dcee01b45
parent50518ec296aea3af3e00c43c2ccef74c96cb5762
Fix table rewrites that include a column without a default.

In c2fe139c201c I made ATRewriteTable() use tuple slots. Unfortunately
I did not notice that columns can be added in a rewrite that do not
have a default, when another column is added/altered requiring one.

Initialize columns to NULL again, and add tests.

Bug: #16038
Reported-By: anonymous
Author: Andres Freund
Discussion: https://postgr.es/m/16038-5c974541f2bf6749@postgresql.org
Backpatch: 12, where the bug was introduced in c2fe139c201c
src/backend/commands/tablecmds.c
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql