diff options
author | Michael Meskes <meskes@postgresql.org> | 1999-04-14 18:51:37 +0000 |
---|---|---|
committer | Michael Meskes <meskes@postgresql.org> | 1999-04-14 18:51:37 +0000 |
commit | 29e2916827467f7d2f8f38c57dc294f65576f4a9 (patch) | |
tree | 9ba0a1e6fd866b0ed69dcc5a30b50e1deb74753c /src/interfaces/ecpg/test | |
parent | 9a4344e73e02eeed321cdc1ca63ae50405808ef0 (diff) |
*** empty log message ***
Diffstat (limited to 'src/interfaces/ecpg/test')
-rw-r--r-- | src/interfaces/ecpg/test/test1.pgc | 7 |
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; |