Horton

Propagate ALTER TABLE ... SET STORAGE to indexes

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 03a8a5f2d4a1f9886ad1d62d3f70424dfcdf8048
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2020-05-08T07:30:57Z
Releases: 11.8 
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 +48 −0
src/test/regress/expected/alter_table.out modified +20 −0
src/test/regress/sql/alter_table.sql modified +6 −0

Discussion