Line data    Source code

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