Horton

Propagate ALTER TABLE ... SET STORAGE to indexes

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 501e41dd3cb945287fdcfe25e8906e79872fcc44
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2020-05-08T06:39:17Z
Releases: 13.0 
Propagate ALTER TABLE ... SET STORAGE to indexes

When creating a new index, the attstorage setting of the table column
is copied to regular (non-expression) index columns.  But a later
ALTER TABLE ... SET STORAGE is not propagated to indexes, thus
creating an inconsistent and undumpable state.

Discussion: https://www.postgresql.org/message-id/flat/9765d72b-37c0-06f5-e349-2a580aafd989%402ndquadrant.com

Files

PathChange+/−
contrib/test_decoding/expected/toast.out modified +4 −0
contrib/test_decoding/sql/toast.sql modified +5 −0
src/backend/commands/tablecmds.c modified +47 −0
src/test/regress/expected/alter_table.out modified +20 −0
src/test/regress/expected/vacuum.out modified +2 −2
src/test/regress/sql/alter_table.sql modified +6 −0
src/test/regress/sql/vacuum.sql modified +2 −2

Discussion