Fix temporary tablespaces for shared filesets some more.

tglsfdc · tglsfdc · commit a7d3f3b836a0 · 2020-07-03T17:01:34.000-04:00
Commit ecd9e9f fixed the problem in the wrong place, causing unwanted side-effects on the behavior of GetNextTempTableSpace(). Instead, let's make SharedFileSetInit() responsible for subbing in the value of MyDatabaseTableSpace when the default tablespace is called for. The convention about what is in the tempTableSpaces[] array is evidently insufficiently documented, so try to improve that. It also looks like SharedFileSetInit() is doing the wrong thing in the case where temp_tablespaces is empty. It was hard-wiring use of the pg_default tablespace, but it seems like using MyDatabaseTableSpace is more consistent with what happens for other temp files. Back-patch the reversion of PrepareTempTablespaces()'s behavior to 9.5, as ecd9e9f was. The changes in SharedFileSetInit() go back to v11 where that was introduced. (Note there is net zero code change before v11 from these two patch sets, so nothing to release-note.) Magnus Hagander and Tom Lane Discussion: https://postgr.es/m/CABUevExg5YEsOvqMxrjoNvb3ApVyH+9jggWGKwTDFyFCVWczGQ@mail.gmail.com
diff --git a/src/backend/commands/tablespace.c b/src/backend/commands/tablespace.c
@@ -1149,6 +1149,7 @@ GetDefaultTablespace(char relpersistence)
 
 typedef struct
 {
+	/* Array of OIDs to be passed to SetTempTablespaces() */
 	int			numSpcs;
 	Oid			tblSpcs[FLEXIBLE_ARRAY_MEMBER];
 } temp_tablespaces_extra;
@@ -1198,6 +1199,7 @@ check_temp_tablespaces(char **newval, void **extra, GucSource source)
 			/* Allow an empty string (signifying database default) */
 			if (curname[0] == '\0')
 			{
+				/* InvalidOid signifies database's default tablespace */
 				tblSpcs[numSpcs++] = InvalidOid;
 				continue;
 			}
@@ -1224,6 +1226,7 @@ check_temp_tablespaces(char **newval, void **extra, GucSource source)
 			 */
 			if (curoid == MyDatabaseTableSpace)
 			{
+				/* InvalidOid signifies database's default tablespace */
 				tblSpcs[numSpcs++] = InvalidOid;
 				continue;
 			}
@@ -1334,6 +1337,7 @@ PrepareTempTablespaces(void)
 		/* Allow an empty string (signifying database default) */
 		if (curname[0] == '\0')
 		{
+			/* InvalidOid signifies database's default tablespace */
 			tblSpcs[numSpcs++] = InvalidOid;
 			continue;
 		}
@@ -1352,7 +1356,8 @@ PrepareTempTablespaces(void)
 		 */
 		if (curoid == MyDatabaseTableSpace)
 		{
-			tblSpcs[numSpcs++] = curoid;
+			/* InvalidOid signifies database's default tablespace */
+			tblSpcs[numSpcs++] = InvalidOid;
 			continue;
 		}
 
diff --git a/src/backend/storage/file/fd.c b/src/backend/storage/file/fd.c
@@ -253,8 +253,10 @@ static AllocateDesc *allocatedDescs = NULL;
 static long tempFileCounter = 0;
 
 /*
- * Array of OIDs of temp tablespaces.  When numTempTableSpaces is -1,
- * this has not been set in the current transaction.
+ * Array of OIDs of temp tablespaces.  (Some entries may be InvalidOid,
+ * indicating that the current database's default tablespace should be used.)
+ * When numTempTableSpaces is -1, this has not been set in the current
+ * transaction.
  */
 static Oid *tempTableSpaces = NULL;
 static int	numTempTableSpaces = -1;
@@ -2576,6 +2578,9 @@ closeAllVfds(void)
  * unless this function is called again before then.  It is caller's
  * responsibility that the passed-in array has adequate lifespan (typically
  * it'd be allocated in TopTransactionContext).
+ *
+ * Some entries of the array may be InvalidOid, indicating that the current
+ * database's default tablespace should be used.
  */
 void
 SetTempTablespaces(Oid *tableSpaces, int numSpaces)

Original file line number	Diff line number	Diff line change
`@@ -1149,6 +1149,7 @@ GetDefaultTablespace(char relpersistence)`
`1149`	`1149`
`1150`	`1150`	`typedef struct`
`1151`	`1151`	`{`
	`1152`	`+ /* Array of OIDs to be passed to SetTempTablespaces() */`
`1152`	`1153`	`int numSpcs;`
`1153`	`1154`	`Oid tblSpcs[FLEXIBLE_ARRAY_MEMBER];`
`1154`	`1155`	`} temp_tablespaces_extra;`
`@@ -1198,6 +1199,7 @@ check_temp_tablespaces(char newval, void extra, GucSource source)`
`1198`	`1199`	`/* Allow an empty string (signifying database default) */`
`1199`	`1200`	`if (curname[0] == '\0')`
`1200`	`1201`	`{`
	`1202`	`+ /* InvalidOid signifies database's default tablespace */`
`1201`	`1203`	`tblSpcs[numSpcs++] = InvalidOid;`
`1202`	`1204`	`continue;`
`1203`	`1205`	`}`
`@@ -1224,6 +1226,7 @@ check_temp_tablespaces(char newval, void extra, GucSource source)`
`1224`	`1226`	`*/`
`1225`	`1227`	`if (curoid == MyDatabaseTableSpace)`
`1226`	`1228`	`{`
	`1229`	`+ /* InvalidOid signifies database's default tablespace */`
`1227`	`1230`	`tblSpcs[numSpcs++] = InvalidOid;`
`1228`	`1231`	`continue;`
`1229`	`1232`	`}`
`@@ -1334,6 +1337,7 @@ PrepareTempTablespaces(void)`
`1334`	`1337`	`/* Allow an empty string (signifying database default) */`
`1335`	`1338`	`if (curname[0] == '\0')`
`1336`	`1339`	`{`
	`1340`	`+ /* InvalidOid signifies database's default tablespace */`
`1337`	`1341`	`tblSpcs[numSpcs++] = InvalidOid;`
`1338`	`1342`	`continue;`
`1339`	`1343`	`}`
`@@ -1352,7 +1356,8 @@ PrepareTempTablespaces(void)`
`1352`	`1356`	`*/`
`1353`	`1357`	`if (curoid == MyDatabaseTableSpace)`
`1354`	`1358`	`{`
`1355`		`- tblSpcs[numSpcs++] = curoid;`
	`1359`	`+ /* InvalidOid signifies database's default tablespace */`
	`1360`	`+ tblSpcs[numSpcs++] = InvalidOid;`
`1356`	`1361`	`continue;`
`1357`	`1362`	`}`
`1358`	`1363`