postgres.git / summary / log / commit / refs

commit    08b53281f4444efb2d5bcc44d6293b05d1aa1335
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Fri Jan 18 01:51:52 2019 +0000
First released in: 12.0, 10.7, 11.2

    Enforce non-parallel plan when calling current_schema() in newly-added test
    
    current_schema() gets called in the recently-added regression test from
    c5660e0, and can be used in a parallel context, causing its call to fail
    when creating a temporary schema.
    
    Per buildfarm members crake and lapwing.
    
    Discussion: https://postgr.es/m/20190118005949.GD1883@paquier.xyz


 src/test/regress/expected/temp.out | 5 ++++-
 src/test/regress/sql/temp.sql      | 5 ++++-
 2 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/src/test/regress/expected/temp.out b/src/test/regress/expected/temp.out
index e677d6b86fc..bba4a7ae565 100644
--- a/src/test/regress/expected/temp.out
+++ b/src/test/regress/expected/temp.out
@@ -360,8 +360,11 @@ prepare transaction 'twophase_tab';
 ERROR:  cannot PREPARE a transaction that has operated on temporary tables
 -- Corner case: current_schema may create a temporary schema if namespace
 -- creation is pending, so check after that.  First reset the connection
--- to remove the temporary namespace.
+-- to remove the temporary namespace, and make sure that non-parallel plans
+-- are used.
 \c -
+SET max_parallel_workers = 0;
+SET max_parallel_workers_per_gather = 0;
 SET search_path TO 'pg_temp';
 BEGIN;
 SELECT current_schema() ~ 'pg_temp' AS is_temp_schema;
diff --git a/src/test/regress/sql/temp.sql b/src/test/regress/sql/temp.sql
index df7edd94103..d69a243fe74 100644
--- a/src/test/regress/sql/temp.sql
+++ b/src/test/regress/sql/temp.sql
@@ -274,8 +274,11 @@ prepare transaction 'twophase_tab';
 
 -- Corner case: current_schema may create a temporary schema if namespace
 -- creation is pending, so check after that.  First reset the connection
--- to remove the temporary namespace.
+-- to remove the temporary namespace, and make sure that non-parallel plans
+-- are used.
 \c -
+SET max_parallel_workers = 0;
+SET max_parallel_workers_per_gather = 0;
 SET search_path TO 'pg_temp';
 BEGIN;
 SELECT current_schema() ~ 'pg_temp' AS is_temp_schema;


[parent: b15160bc716e]