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 : :
106 peter@eisentraut.org 7 :GNC 1 : int main(void) {
8 : : EXEC SQL BEGIN DECLARE SECTION;
6524 meskes@postgresql.or 9 :CBC 1 : char var[25] = "public";
10 : : EXEC SQL END DECLARE SECTION;
11 : :
7272 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 : :
6524 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 : :
7209 22 : 1 : EXEC SQL SET search_path TO 'public';
7272 23 [ - + - + ]: 1 : EXEC SQL SHOW search_path INTO :var;
24 [ - + - + ]: 1 : printf("Var: Search path: %s\n", var);
25 : :
160 tgl@sss.pgh.pa.us 26 :GNC 1 : EXEC SQL SET standard_conforming_strings TO on;
7272 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 : :
7209 30 : 1 : EXEC SQL SET TIME ZONE PST8PDT;
7272 31 [ - + - + ]: 1 : EXEC SQL SHOW TIME ZONE INTO :var;
32 [ - + - + ]: 1 : printf("Time Zone: %s\n", var);
33 : :
7209 34 : 1 : EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
7272 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 : : }
|
