From 2047f054facf3ffaff31e36591279b9bd76ca53c Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Fri, 18 Jan 2019 19:06:40 -0300 Subject: [PATCH 1/2] Add missing relcache reset Adding a foreign key to a partitioned table requires applying a relcache reset to each partition, so that the newly added FK is correctly recorded in its entry on next rebuild. With the previous coding of ATAddForeignKeyConstraint, this may not have been necessary, but with the one after 0325d7a5957b, it is. Noted while testing another bugfix. --- src/backend/commands/tablecmds.c | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c index 1a1ac698e5..5a27f64aa7 100644 --- a/src/backend/commands/tablecmds.c +++ b/src/backend/commands/tablecmds.c @@ -7700,6 +7700,12 @@ ATAddForeignKeyConstraint(List **wqueue, AlteredTableInfo *tab, Relation rel, childtab->constraints = lappend(childtab->constraints, newcon); + /* + * Also invalidate the partition's relcache entry, so that its + * FK list gets updated on next rebuild. + */ + CacheInvalidateRelcache(partition); + heap_close(partition, lockmode); } } -- 2.11.0