summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test
diff options
context:
space:
mode:
authorMichael Meskes <meskes@postgresql.org>1999-04-14 18:51:37 +0000
committerMichael Meskes <meskes@postgresql.org>1999-04-14 18:51:37 +0000
commit29e2916827467f7d2f8f38c57dc294f65576f4a9 (patch)
tree9ba0a1e6fd866b0ed69dcc5a30b50e1deb74753c /src/interfaces/ecpg/test
parent9a4344e73e02eeed321cdc1ca63ae50405808ef0 (diff)
*** empty log message ***
Diffstat (limited to 'src/interfaces/ecpg/test')
-rw-r--r--src/interfaces/ecpg/test/test1.pgc7
1 files changed, 5 insertions, 2 deletions
diff --git a/src/interfaces/ecpg/test/test1.pgc b/src/interfaces/ecpg/test/test1.pgc
index 2dec961a4d6..bed83f96380 100644
--- a/src/interfaces/ecpg/test/test1.pgc
+++ b/src/interfaces/ecpg/test/test1.pgc
@@ -2,6 +2,7 @@ exec sql whenever sqlerror sqlprint;
exec sql include sqlca;
+/* comment */
exec sql define AMOUNT 4;
exec sql type intarray is int[AMOUNT];
@@ -42,7 +43,7 @@ exec sql end declare section;
exec sql commit;
strcpy(msg, "set connection");
- exec sql set connection main;
+ exec sql set connection to main;
strcpy(msg, "execute insert 1");
sprintf(command, "insert into test(name, amount, letter) values ('db: mm', 1, 'f')");
@@ -69,7 +70,9 @@ exec sql end declare section;
strcpy(msg, "commit");
exec sql commit;
- exec sql at pm commit;
+
+ /* Stop automatic transactioning for connection pm. */
+ exec sql at pm set autocommit to off;
strcpy(msg, "select");
exec sql select name, amount, letter into :name, :amount, :letter from test;