Horton

Make constraint rename issue relcache invalidation on target relation

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: b13fd344c5fce6a2f95b758e97b79eb00adf2731
Author: Michael Paquier <michael@paquier.xyz>
Date: 2018-12-17T01:34:44Z
Releases: 12.0 
Make constraint rename issue relcache invalidation on target relation

When a constraint gets renamed, it may have associated with it a target
relation (for example domain constraints don't have one).  Not
invalidating the target relation cache when issuing the renaming can
result in issues with subsequent commands that refer to the old
constraint name using the relation cache, causing various failures.  One
pattern spotted was using CREATE TABLE LIKE after a constraint
renaming.

Reported-by: Stuart <sfbarbee@gmail.com>
Author: Amit Langote
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/2047094.V130LYfLq4@station53.ousa.org

Files

PathChange+/−
src/backend/commands/tablecmds.c modified +7 −0
src/test/regress/expected/alter_table.out modified +22 −0
src/test/regress/sql/alter_table.sql modified +14 −0

Discussion