postgres
diff --git a/‎src/backend/commands/indexcmds.c
Copy file name to clipboardExpand all lines: src/backend/commands/indexcmds.c
+11-1Lines changed: 11 additions & 1 deletion b/‎src/backend/commands/indexcmds.c
Copy file name to clipboardExpand all lines: src/backend/commands/indexcmds.c
+11-1Lines changed: 11 additions & 1 deletion
diff --git a/‎src/test/regress/expected/insert_conflict.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/insert_conflict.out
+1-1Lines changed: 1 addition & 1 deletion b/‎src/test/regress/expected/insert_conflict.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/insert_conflict.out
+1-1Lines changed: 1 addition & 1 deletion
diff --git a/‎src/test/regress/sql/insert_conflict.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/insert_conflict.sql
+1-1Lines changed: 1 addition & 1 deletion b/‎src/test/regress/sql/insert_conflict.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/insert_conflict.sql
+1-1Lines changed: 1 addition & 1 deletion
@@ -833,8 +833,18 @@ DefineIndex(Oid relationId,
 		flags |= INDEX_CREATE_PARTITIONED;
 	if (stmt->primary)
 		flags |= INDEX_CREATE_IS_PRIMARY;
+
+	/*
+	 * If the table is partitioned, and recursion was declined but partitions
+	 * exist, mark the index as invalid.
+	 */
 	if (partitioned && stmt->relation && !stmt->relation->inh)
-		flags |= INDEX_CREATE_INVALID;
+	{
+		PartitionDesc	pd = RelationGetPartitionDesc(rel);
+
+		if (pd->nparts != 0)
+			flags |= INDEX_CREATE_INVALID;
+	}
 
 	if (stmt->deferrable)
 		constr_flags |= INDEX_CONSTR_CREATE_DEFERRABLE;
 
@@ -813,10 +813,10 @@ drop table parted_conflict;
 -- partition
 create table parted_conflict (a int, b text) partition by range (a);
 create table parted_conflict_1 partition of parted_conflict for values from (0) to (1000) partition by range (a);
+create table parted_conflict_1_1 partition of parted_conflict_1 for values from (0) to (500);
 create unique index on only parted_conflict_1 (a);
 create unique index on only parted_conflict (a);
 alter index parted_conflict_a_idx attach partition parted_conflict_1_a_idx;
-create table parted_conflict_1_1 partition of parted_conflict_1 for values from (0) to (500);
 insert into parted_conflict values (40, 'forty');
 insert into parted_conflict_1 values (40, 'cuarenta')
   on conflict (a) do update set b = excluded.b;
 
@@ -528,10 +528,10 @@ drop table parted_conflict;
 -- partition
 create table parted_conflict (a int, b text) partition by range (a);
 create table parted_conflict_1 partition of parted_conflict for values from (0) to (1000) partition by range (a);
+create table parted_conflict_1_1 partition of parted_conflict_1 for values from (0) to (500);
 create unique index on only parted_conflict_1 (a);
 create unique index on only parted_conflict (a);
 alter index parted_conflict_a_idx attach partition parted_conflict_1_a_idx;
-create table parted_conflict_1_1 partition of parted_conflict_1 for values from (0) to (500);
 insert into parted_conflict values (40, 'forty');
 insert into parted_conflict_1 values (40, 'cuarenta')
   on conflict (a) do update set b = excluded.b;