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                 :                : 
 5443 meskes@postgresql.or        7                 :CBC           1 : int main() {
                                  8                 :                :   EXEC SQL BEGIN DECLARE SECTION;
 5717                             9                 :              1 :     char var[25] = "public";
                                 10                 :                :   EXEC SQL END DECLARE SECTION;
                                 11                 :                : 
 6465                            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                 :                : 
 5717                            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                 :                : 
 6402                            22                 :              1 :   EXEC SQL SET search_path TO 'public';
 6465                            23   [ -  +  -  + ]:              1 :   EXEC SQL SHOW search_path INTO :var;
                                 24   [ -  +  -  + ]:              1 :   printf("Var: Search path: %s\n", var);
                                 25                 :                : 
 6402                            26                 :              1 :   EXEC SQL SET standard_conforming_strings TO off;
 6465                            27   [ -  +  -  + ]:              1 :   EXEC SQL SHOW standard_conforming_strings INTO :var;
                                 28   [ -  +  -  + ]:              1 :   printf("Var: Standard conforming strings: %s\n", var);
                                 29                 :                : 
 6402                            30                 :              1 :   EXEC SQL SET TIME ZONE PST8PDT;
 6465                            31   [ -  +  -  + ]:              1 :   EXEC SQL SHOW TIME ZONE INTO :var;
                                 32   [ -  +  -  + ]:              1 :   printf("Time Zone: %s\n", var);
                                 33                 :                : 
 6402                            34                 :              1 :   EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
 6465                            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                 :                : }