]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Make constraint rename issue relcache invalidation on target relation
authorMichael Paquier <michael@paquier.xyz>
Mon, 17 Dec 2018 01:36:03 +0000 (10:36 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 17 Dec 2018 01:36:03 +0000 (10:36 +0900)
commit25b8094d33ac66773ba1418457cb74eb22b5d50a
tree2a3623c88fc60b94a643d2fb5771ab74e664f16f
parentb054498c74c3630348b9a35f7f4c6dc90e204643
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
src/backend/commands/tablecmds.c
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql