"UseTempDb" setting for PostgreSQL is not working properly

[fabionaspolini]

Both add the "temp" keyword on "create table" statement only when the "unlogged" argument is true, but the correct thing would be to add it when the "useTempDb" argument is true.

EFCore.BulkExtensions/EFCore.BulkExtensions.PostgreSql/SqlAdapters/PostgreSql/PostgreSqlQueryBuilder.cs

Lines 22 to 36 in 9ea847e

	public static string CreateOutputStatsTable(string newTableName, bool useTempDb, bool unlogged)
	{
	string keywordPrefix = "";
	if (unlogged == true)
	{
	keywordPrefix = "TEMP "; // "TEMP " or "TEMPORARY "
	}
	else if(unlogged) // can not be combined with TEMP since Temporary tables are not logged by default.
	{
	keywordPrefix = "UNLOGGED ";
	}
	var q = @$"CREATE {keywordPrefix}TABLE IF NOT EXISTS {newTableName} (""xmaxNumber"" xid)"; // col name can't be just 'xmax' - conflicts with system column
	q = q.Replace("[", @"""").Replace("]", @"""");
	return q;
	}