Horton

addFkRecurseReferencing-fix.patch

text/plain

Download
Filename: addFkRecurseReferencing-fix.patch
Type: text/plain
Part: 0
Message: Re: partitioned tables referenced by FKs

Patch

Format: unified
File+−
src/backend/commands/tablecmds.c 1 3 
diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c
index 8e26053a5c..2ad30c8452 100644
--- a/src/backend/commands/tablecmds.c
+++ b/src/backend/commands/tablecmds.c
@@ -8105,7 +8105,6 @@ addFkRecurseReferencing(List **wqueue, Constraint *fkconstraint, Relation rel,
 			AttrNumber *attmap;
 			AttrNumber	mapped_fkattnum[INDEX_MAX_KEYS];
 			bool		attached;
-			Oid			partIndexOid;
 			char	   *conname;
 			Oid			constrOid;
 			ObjectAddress address,
@@ -8148,7 +8147,6 @@ addFkRecurseReferencing(List **wqueue, Constraint *fkconstraint, Relation rel,
 			/*
 			 * No luck finding a good constraint to reuse; create our own.
 			 */
-			partIndexOid = index_get_partition(partition, indexOid);
 			if (ConstraintNameIsUsed(CONSTRAINT_RELATION,
 									 RelationGetRelid(partition),
 									 fkconstraint->conname))
@@ -8171,7 +8169,7 @@ addFkRecurseReferencing(List **wqueue, Constraint *fkconstraint, Relation rel,
 									  numfks,
 									  numfks,
 									  InvalidOid,
-									  partIndexOid,
+									  indexOid,
 									  RelationGetRelid(pkrel),
 									  pkattnum,
 									  pfeqoperators,