1 files changed, 4 insertions, 6 deletions
diff --git a/src/interfaces/ecpg/test/sql/show.pgc b/src/interfaces/ecpg/test/sql/show.pgc
index afa2cee908..8eb71a7262 100644
--- a/src/interfaces/ecpg/test/sql/show.pgc
+++ b/src/interfaces/ecpg/test/sql/show.pgc
@@ -15,24 +15,22 @@ int main(int argc, char* argv[]) {
   EXEC SQL WHENEVER SQLWARNING SQLPRINT;
   EXEC SQL WHENEVER SQLERROR SQLPRINT;
 
+  EXEC SQL SET search_path TO 'public';
   EXEC SQL SHOW search_path INTO :var;
   printf("Var: Search path: %s\n", var);
 
-  EXEC SQL SHOW wal_buffers INTO :var;
-  printf("Var: WAL buffers: %s\n", var);
-
+  EXEC SQL SET standard_conforming_strings TO off;
   EXEC SQL SHOW standard_conforming_strings INTO :var;
   printf("Var: Standard conforming strings: %s\n", var);
 
+  EXEC SQL SET TIME ZONE PST8PDT;
   EXEC SQL SHOW TIME ZONE INTO :var;
   printf("Time Zone: %s\n", var);
 
+  EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
   EXEC SQL SHOW TRANSACTION ISOLATION LEVEL INTO :var;
   printf("Transaction isolation level: %s\n", var);
 
-  /* Do not ask for the user name, it may differ in a regression test */
-  /* EXEC SQL SHOW SESSION AUTHORIZATION INTO :var; */
-
   EXEC SQL DISCONNECT ALL;
 
   return 0;