Age         Owner                    Branch data    TLA  Line data    Source code

                                  1                 :                : #include <stdio.h>
                                  2                 :                : #include <stdlib.h>
                                  3                 :                : #include <string.h>
                                  4                 :                : 
                                  5                 :                : EXEC SQL INCLUDE ../regression;
                                  6                 :                : 
   50 peter@eisentraut.org        7                 :GNC           1 : int main(void) {
                                  8                 :                :   EXEC SQL BEGIN DECLARE SECTION;
 6468 meskes@postgresql.or        9                 :CBC           1 :     char var[25] = "public";
                                 10                 :                :   EXEC SQL END DECLARE SECTION;
                                 11                 :                : 
 7216                            12                 :              1 :   ECPGdebug(1, stderr);
                                 13                 :              1 :   EXEC SQL CONNECT TO REGRESSDB1;
                                 14                 :                : 
                                 15                 :                :   EXEC SQL WHENEVER SQLWARNING SQLPRINT;
                                 16                 :                :   EXEC SQL WHENEVER SQLERROR SQLPRINT;
                                 17                 :                : 
 6468                            18                 :              1 :   EXEC SQL SET search_path TO :var;
                                 19   [ -  +  -  + ]:              1 :   EXEC SQL SHOW search_path INTO :var;
                                 20   [ -  +  -  + ]:              1 :   printf("Var: Search path: %s\n", var);
                                 21                 :                : 
 7153                            22                 :              1 :   EXEC SQL SET search_path TO 'public';
 7216                            23   [ -  +  -  + ]:              1 :   EXEC SQL SHOW search_path INTO :var;
                                 24   [ -  +  -  + ]:              1 :   printf("Var: Search path: %s\n", var);
                                 25                 :                : 
  104 tgl@sss.pgh.pa.us          26                 :GNC           1 :   EXEC SQL SET standard_conforming_strings TO on;
 7216 meskes@postgresql.or       27   [ -  +  -  + ]:CBC           1 :   EXEC SQL SHOW standard_conforming_strings INTO :var;
                                 28   [ -  +  -  + ]:              1 :   printf("Var: Standard conforming strings: %s\n", var);
                                 29                 :                : 
 7153                            30                 :              1 :   EXEC SQL SET TIME ZONE PST8PDT;
 7216                            31   [ -  +  -  + ]:              1 :   EXEC SQL SHOW TIME ZONE INTO :var;
                                 32   [ -  +  -  + ]:              1 :   printf("Time Zone: %s\n", var);
                                 33                 :                : 
 7153                            34                 :              1 :   EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
 7216                            35   [ -  +  -  + ]:              1 :   EXEC SQL SHOW TRANSACTION ISOLATION LEVEL INTO :var;
                                 36   [ -  +  -  + ]:              1 :   printf("Transaction isolation level: %s\n", var);
                                 37                 :                : 
                                 38                 :              1 :   EXEC SQL DISCONNECT ALL;
                                 39   [ -  +  -  + ]:              1 : 
                                 40                 :              1 :   return 0;
                                 41                 :                : }