postgres
diff --git a/‎src/backend/commands/tablecmds.c
Copy file name to clipboardExpand all lines: src/backend/commands/tablecmds.c
+2-2Lines changed: 2 additions & 2 deletions b/‎src/backend/commands/tablecmds.c
Copy file name to clipboardExpand all lines: src/backend/commands/tablecmds.c
+2-2Lines changed: 2 additions & 2 deletions
diff --git a/‎src/test/regress/expected/alter_table.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/alter_table.out
+1-1Lines changed: 1 addition & 1 deletion b/‎src/test/regress/expected/alter_table.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/alter_table.out
+1-1Lines changed: 1 addition & 1 deletion
diff --git a/‎src/test/regress/sql/alter_table.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/alter_table.sql
+1-1Lines changed: 1 addition & 1 deletion b/‎src/test/regress/sql/alter_table.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/alter_table.sql
+1-1Lines changed: 1 addition & 1 deletion
@@ -3020,12 +3020,12 @@ rename_constraint_internal(Oid myrelid,
 
 	if (targetrelation)
 	{
-		relation_close(targetrelation, NoLock); /* close rel but keep lock */
-
 		/*
 		 * Invalidate relcache so as others can see the new constraint name.
 		 */
 		CacheInvalidateRelcache(targetrelation);
+
+		relation_close(targetrelation, NoLock); /* close rel but keep lock */
 	}
 
 	return address;
 
@@ -400,7 +400,7 @@ CREATE TABLE constraint_rename_cache (a int,
 ALTER TABLE constraint_rename_cache
   RENAME CONSTRAINT chk_a TO chk_a_new;
 ALTER TABLE constraint_rename_cache
-  RENAME CONSTRAINT constraint_rename_cache_pkey TO chk_a_gt_zero;
+  RENAME CONSTRAINT constraint_rename_cache_pkey TO constraint_rename_pkey_new;
 CREATE TABLE like_constraint_rename_cache
   (LIKE constraint_rename_cache INCLUDING ALL);
 \d like_constraint_rename_cache
 
@@ -296,7 +296,7 @@ CREATE TABLE constraint_rename_cache (a int,
 ALTER TABLE constraint_rename_cache
   RENAME CONSTRAINT chk_a TO chk_a_new;
 ALTER TABLE constraint_rename_cache
-  RENAME CONSTRAINT constraint_rename_cache_pkey TO chk_a_gt_zero;
+  RENAME CONSTRAINT constraint_rename_cache_pkey TO constraint_rename_pkey_new;
 CREATE TABLE like_constraint_rename_cache
   (LIKE constraint_rename_cache INCLUDING ALL);
 \d like_constraint_rename_cache
Original file line number	Diff line number	Diff line change
`@@ -3020,12 +3020,12 @@ rename_constraint_internal(Oid myrelid,`
`3020`	`3020`
`3021`	`3021`	`if (targetrelation)`
`3022`	`3022`	`{`
`3023`		`- relation_close(targetrelation, NoLock); /* close rel but keep lock */`
`3024`		`-`
`3025`	`3023`	`/*`
`3026`	`3024`	`* Invalidate relcache so as others can see the new constraint name.`
`3027`	`3025`	`*/`
`3028`	`3026`	`CacheInvalidateRelcache(targetrelation);`
	`3027`	`+`
	`3028`	`+ relation_close(targetrelation, NoLock); /* close rel but keep lock */`
`3029`	`3029`	`}`
`3030`	`3030`
`3031`	`3031`	`return address;`