*** /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stdout 2009-10-03 04:23:59.000000000 -0400 --- /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/results/compat_informix-sqlda.stdout 2009-10-04 01:52:52.000000000 -0400 *************** *** 1,60 **** - FETCH RECORD 1 - name sqlda descriptor: 'id' value 1 - name sqlda descriptor: 't' value 'a' - name sqlda descriptor: 'd1' value DECIMAL '1.0' - name sqlda descriptor: 'd2' value 1.000000 - name sqlda descriptor: 'c' value 'a ' - FETCH RECORD 2 - name sqlda descriptor: 'id' value 2 - name sqlda descriptor: 't' value NULL' - name sqlda descriptor: 'd1' value NULL' - name sqlda descriptor: 'd2' value NULL' - name sqlda descriptor: 'c' value NULL' - FETCH RECORD 3 - name sqlda descriptor: 'id' value 3 - name sqlda descriptor: 't' value '"c"' - name sqlda descriptor: 'd1' value DECIMAL '-3' - name sqlda descriptor: 'd2' value nan - name sqlda descriptor: 'c' value 'c ' - FETCH RECORD 4 - name sqlda descriptor: 'id' value 4 - name sqlda descriptor: 't' value 'd' - name sqlda descriptor: 'd1' value DECIMAL '4.0' - name sqlda descriptor: 'd2' value 4.000000 - name sqlda descriptor: 'c' value 'd ' - FETCH RECORD 1 - name sqlda descriptor: 'id' value 1 - name sqlda descriptor: 't' value 'a' - name sqlda descriptor: 'd1' value DECIMAL '1.0' - name sqlda descriptor: 'd2' value 1.000000 - name sqlda descriptor: 'c' value 'a ' - FETCH RECORD 2 - name sqlda descriptor: 'id' value 2 - name sqlda descriptor: 't' value NULL' - name sqlda descriptor: 'd1' value NULL' - name sqlda descriptor: 'd2' value NULL' - name sqlda descriptor: 'c' value NULL' - FETCH RECORD 3 - name sqlda descriptor: 'id' value 3 - name sqlda descriptor: 't' value '"c"' - name sqlda descriptor: 'd1' value DECIMAL '-3' - name sqlda descriptor: 'd2' value nan - name sqlda descriptor: 'c' value 'c ' - FETCH RECORD 4 - name sqlda descriptor: 'id' value 4 - name sqlda descriptor: 't' value 'd' - name sqlda descriptor: 'd1' value DECIMAL '4.0' - name sqlda descriptor: 'd2' value 4.000000 - name sqlda descriptor: 'c' value 'd ' - EXECUTE RECORD 4 - name sqlda descriptor: 'id' value 4 - name sqlda descriptor: 't' value 'd' - name sqlda descriptor: 'd1' value DECIMAL '4.0' - name sqlda descriptor: 'd2' value 4.000000 - name sqlda descriptor: 'c' value 'd ' - EXECUTE RECORD 4 - name sqlda descriptor: 'id' value 4 - name sqlda descriptor: 't' value 'd' - name sqlda descriptor: 'd1' value DECIMAL '4.0' - name sqlda descriptor: 'd2' value 4.000000 - name sqlda descriptor: 'c' value 'd ' --- 0 ---- ====================================================================== *** /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr 2009-10-03 04:23:59.000000000 -0400 --- /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/results/compat_informix-sqlda.stderr 2009-10-04 01:52:52.000000000 -0400 *************** *** 36,252 **** [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 111: new sqlda was built [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_get_data on line 111: RESULT: 1 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: 1.0 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: 1 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: 2 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: 3 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: -3 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: NaN offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: 4.0 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 111: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: query: fetch 1 from mycur1; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 111: correctly got 0 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: raising sqlcode 100 on line 111: no data found on line 111 - [NO_PID]: sqlca: code: 100, state: 02000 - [NO_PID]: ecpg_execute on line 120: query: close mycur1; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 120: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 120: OK: CLOSE CURSOR - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGdeallocate on line 123: name st_id1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGprepare on line 134: name st_id2; query: "SELECT * FROM t1" - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 140: query: declare mycur2 cursor for SELECT * FROM t1; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 140: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 140: OK: DECLARE CURSOR - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: query: fetch from mycur2; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 1 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 1.0 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 1 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: query: fetch from mycur2; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 2 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: query: fetch from mycur2; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 3 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: -3 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: NaN offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: query: fetch from mycur2; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 4.0 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 148: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: query: fetch from mycur2; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 148: correctly got 0 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: raising sqlcode 100 on line 148: no data found on line 148 - [NO_PID]: sqlca: code: 100, state: 02000 - [NO_PID]: ecpg_execute on line 157: query: close mycur2; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 157: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 157: OK: CLOSE CURSOR - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGdeallocate on line 160: name st_id2 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGprepare on line 183: name st_id3; query: "SELECT * FROM t1 WHERE id = $1" - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 186: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 186: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1" - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: free_params on line 186: parameter 1 = 4 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 186: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 186: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 186: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 186: RESULT: 4.0 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 186: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 186: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGdeallocate on line 191: name st_id3 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGconnect: opening database regress1 on port - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGprepare on line 220: name st_id4; query: "SELECT * FROM t1 WHERE id = $1" - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 223: query: SELECT * FROM t1 WHERE id = $1; with 1 parameter(s) on connection con2 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 223: using PQexecPrepared for "SELECT * FROM t1 WHERE id = $1" - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: free_params on line 223: parameter 1 = 4 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 223: correctly got 1 tuples with 5 fields - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 223: new sqlda was built - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 223: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 223: RESULT: 4.0 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_get_data on line 223: RESULT: 4 offset: -1; array: yes - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 223: putting result (1 tuple 5 fields) into sqlda descriptor - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGtrans on line 228: action "commit"; connection "con2" - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGdeallocate on line 231: name st_id4 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_finish: connection con2 closed - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 243: query: drop table t1; with 0 parameter(s) on connection regress1 - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 243: using PQexec - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_execute on line 243: OK: DROP TABLE - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ECPGtrans on line 246: action "commit"; connection "regress1" - [NO_PID]: sqlca: code: 0, state: 00000 - [NO_PID]: ecpg_finish: connection regress1 closed - [NO_PID]: sqlca: code: 0, state: 00000 --- 36,42 ---- [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 111: correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_store_result on line 111: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_get_data on line 111: RESULT: 1 offset: -1; array: yes [NO_PID]: sqlca: code: 0, state: 00000 ====================================================================== *** /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/expected/preproc-cursor.stdout 2009-10-03 04:19:08.000000000 -0400 --- /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/results/preproc-cursor.stdout 2009-10-04 01:52:53.000000000 -0400 *************** *** 1,24 **** - 1 a - 2 b - 3 c - 4 d - 1 a - 2 b - 1 a - 2 b - 3 c - 4 d - 1 a - 2 b - 1 a - 2 b - 3 c - 4 d - 1 a - 2 b - 1 a - 2 b - 3 c - 4 d - 1 a - 2 b --- 0 ---- ====================================================================== *** /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/expected/preproc-cursor.stderr 2009-10-03 04:19:08.000000000 -0400 --- /home/nm/src/pg/bd-sqlda/src/interfaces/ecpg/test/results/preproc-cursor.stderr 2009-10-04 01:52:53.000000000 -0400 *************** *** 12,372 **** [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 44: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 44: OK: CREATE TABLE ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 47: query: insert into t1 ( id , t ) values ( default , 'a' ); with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 47: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 47: OK: INSERT 0 1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 48: query: insert into t1 ( id , t ) values ( default , 'b' ); with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 48: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 48: OK: INSERT 0 1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 49: query: insert into t1 ( id , t ) values ( default , 'c' ); with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 49: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 49: OK: INSERT 0 1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 50: query: insert into t1 ( id , t ) values ( default , 'd' ); with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 50: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 50: OK: INSERT 0 1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ECPGtrans on line 53: action "commit"; connection "regress1" ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 62: query: declare mycur cursor for select id , t from t1; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 62: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 62: OK: DECLARE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 65: query: fetch from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 65: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 65: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 65: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 65: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 69: query: fetch mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 69: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 69: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 69: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 69: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 73: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 73: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 73: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 73: RESULT: 3 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 73: RESULT: c offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 78: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 78: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 78: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 78: RESULT: 4 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 78: RESULT: d offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 82: query: move absolute 0 in mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 82: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 82: OK: MOVE 0 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 85: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 85: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 85: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 85: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 85: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 90: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 90: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 90: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 90: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 90: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 94: query: close mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 94: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 94: OK: CLOSE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 103: query: declare mycur cursor for select id , t from t1; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 103: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 103: OK: DECLARE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 106: query: fetch from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 106: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 106: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 106: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 106: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 110: query: fetch mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 110: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 110: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 110: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 110: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 114: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 114: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 114: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 114: RESULT: 3 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 114: RESULT: c offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 119: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 119: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 119: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 119: RESULT: 4 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 119: RESULT: d offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 123: query: move absolute 0 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 123: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 123: OK: MOVE 0 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 126: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 126: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 126: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 126: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 126: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 131: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 131: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 131: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 131: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 131: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 135: query: close mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 135: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 135: OK: CLOSE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ECPGprepare on line 140: name st_id1; query: "SELECT id, t FROM t1" ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 146: query: declare mycur cursor for SELECT id, t FROM t1; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 146: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 146: OK: DECLARE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 149: query: fetch from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 149: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 149: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 149: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 149: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 153: query: fetch mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 153: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 153: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 153: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 153: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 157: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 157: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 157: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 157: RESULT: 3 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 157: RESULT: c offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 162: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 162: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 162: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 162: RESULT: 4 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 162: RESULT: d offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 166: query: move absolute 0 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 166: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 166: OK: MOVE 0 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 169: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 169: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 169: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 169: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 169: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 174: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 174: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 174: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 174: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 174: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 178: query: close mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 178: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 178: OK: CLOSE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ECPGdeallocate on line 181: name st_id1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ECPGprepare on line 190: name st_id2; query: "SELECT id, t FROM t1" ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 196: query: declare mycur cursor for SELECT id, t FROM t1; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 196: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 196: OK: DECLARE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 199: query: fetch from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 199: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 199: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 199: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 199: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 203: query: fetch mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 203: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 203: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 203: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 203: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 207: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 207: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 207: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 207: RESULT: 3 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 207: RESULT: c offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 212: query: fetch 1 from mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 212: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 212: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 212: RESULT: 4 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 212: RESULT: d offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 216: query: move absolute 0 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 216: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 216: OK: MOVE 0 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 219: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 219: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 219: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 219: RESULT: 1 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 219: RESULT: a offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 224: query: fetch 1 mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 224: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 224: correctly got 1 tuples with 2 fields ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 224: RESULT: 2 offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_get_data on line 224: RESULT: b offset: -1; array: yes ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 228: query: close mycur; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 228: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 228: OK: CLOSE CURSOR ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ECPGdeallocate on line 231: name st_id2 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 236: query: drop table t1; with 0 parameter(s) on connection regress1 ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 236: using PQexec ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_execute on line 236: OK: DROP TABLE ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ECPGtrans on line 239: action "commit"; connection "regress1" ! [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_finish: connection regress1 closed [NO_PID]: sqlca: code: 0, state: 00000 --- 12,18 ---- [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 44: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 ! [NO_PID]: ecpg_check_PQresult on line 44: ERROR: relation "t1" already exists [NO_PID]: sqlca: code: 0, state: 00000 + [NO_PID]: raising sqlstate 42P07 (sqlcode -400) on line 44: relation "t1" already exists on line 44 + [NO_PID]: sqlca: code: -400, state: 42P07 ======================================================================