- #36255: Fix db_query_temporary() in pgsql

- Prefix temporary table names (helps on restricted hosts)

1 files changed, 3 insertions, 3 deletions

diff --git a/includes/database.pgsql.inc b/includes/database.pgsql.inc
index 89b693bab..8a1e06ebf 100644
--- a/includes/database.pgsql.inc
+++ b/includes/database.pgsql.inc
@@ -253,8 +253,8 @@ function db_query_range($query) {
  *   printf() syntax. Instead of a variable number of query arguments, you may
  *   also pass a single array containing the query arguments.
  * @param $table
- *   The name of the temporary table to select into. This name will not be
- *   prefixed as there is no risk of collision.
+ *   The name of the temporary table to select into. This name will be
+ *   prefixed for compatibility reasons (there is no risk of collision).
  * @return
  *   A database query result resource, or FALSE if the query was not executed
  *   correctly.
@@ -263,7 +263,7 @@ function db_query_temporary($query) {
   $args = func_get_args();
   $tablename = array_pop($args);
 
-  $query = preg_replace('/^SELECT/i', 'CREATE TEMPORARY TABLE '. $tablename .' AS', db_prefix_tables($query));
+  $query = preg_replace('/^SELECT/i', 'CREATE TEMPORARY TABLE {'. $tablename .'} AS SELECT', db_prefix_tables($query));
   if (count($args) > 1) {
     // Check for array (alternative syntax).
     if (is_array($args[1])) {