1[NO_PID]: ECPGdebug: set to 1 2[NO_PID]: sqlca: code: 0, state: 00000 3[NO_PID]: ECPGconnect: opening database ecpg1_regression on <DEFAULT> port <DEFAULT> 4[NO_PID]: sqlca: code: 0, state: 00000 5[NO_PID]: ecpg_execute on line 78: query: set datestyle to iso; with 0 parameter(s) on connection ecpg1_regression 6[NO_PID]: sqlca: code: 0, state: 00000 7[NO_PID]: ecpg_execute on line 78: using PQexec 8[NO_PID]: sqlca: code: 0, state: 00000 9[NO_PID]: ecpg_process_output on line 78: OK: SET 10[NO_PID]: sqlca: code: 0, state: 00000 11[NO_PID]: ecpg_execute on line 81: query: create table a1 ( id serial primary key , t text , d1 numeric , d2 float8 , c character ( 10 ) ); with 0 parameter(s) on connection ecpg1_regression 12[NO_PID]: sqlca: code: 0, state: 00000 13[NO_PID]: ecpg_execute on line 81: using PQexec 14[NO_PID]: sqlca: code: 0, state: 00000 15[NO_PID]: ecpg_process_output on line 81: OK: CREATE TABLE 16[NO_PID]: sqlca: code: 0, state: 00000 17[NO_PID]: ecpg_execute on line 84: query: insert into a1 ( id , t , d1 , d2 , c ) values ( default , 'a' , 1.0 , 2 , 'a' ); with 0 parameter(s) on connection ecpg1_regression 18[NO_PID]: sqlca: code: 0, state: 00000 19[NO_PID]: ecpg_execute on line 84: using PQexec 20[NO_PID]: sqlca: code: 0, state: 00000 21[NO_PID]: ecpg_process_output on line 84: OK: INSERT 0 1 22[NO_PID]: sqlca: code: 0, state: 00000 23[NO_PID]: ecpg_execute on line 85: query: insert into a1 ( id , t , d1 , d2 , c ) values ( default , null , null , null , null ); with 0 parameter(s) on connection ecpg1_regression 24[NO_PID]: sqlca: code: 0, state: 00000 25[NO_PID]: ecpg_execute on line 85: using PQexec 26[NO_PID]: sqlca: code: 0, state: 00000 27[NO_PID]: ecpg_process_output on line 85: OK: INSERT 0 1 28[NO_PID]: sqlca: code: 0, state: 00000 29[NO_PID]: ecpg_execute on line 86: query: insert into a1 ( id , t , d1 , d2 , c ) values ( default , 'b' , 2.0 , 3 , 'b' ); with 0 parameter(s) on connection ecpg1_regression 30[NO_PID]: sqlca: code: 0, state: 00000 31[NO_PID]: ecpg_execute on line 86: using PQexec 32[NO_PID]: sqlca: code: 0, state: 00000 33[NO_PID]: ecpg_process_output on line 86: OK: INSERT 0 1 34[NO_PID]: sqlca: code: 0, state: 00000 35[NO_PID]: ECPGtrans on line 89: action "commit"; connection "ecpg1_regression" 36[NO_PID]: sqlca: code: 0, state: 00000 37[NO_PID]: ecpg_execute on line 40: query: declare mycur cursor for select * from a1; with 0 parameter(s) on connection ecpg1_regression 38[NO_PID]: sqlca: code: 0, state: 00000 39[NO_PID]: ecpg_execute on line 40: using PQexec 40[NO_PID]: sqlca: code: 0, state: 00000 41[NO_PID]: ecpg_process_output on line 40: OK: DECLARE CURSOR 42[NO_PID]: sqlca: code: 0, state: 00000 43[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression 44[NO_PID]: sqlca: code: 0, state: 00000 45[NO_PID]: ecpg_execute on line 49: using PQexec 46[NO_PID]: sqlca: code: 0, state: 00000 47[NO_PID]: ecpg_process_output on line 49: correctly got 1 tuples with 5 fields 48[NO_PID]: sqlca: code: 0, state: 00000 49[NO_PID]: ecpg_get_data on line 49: RESULT: 1 offset: -1; array: no 50[NO_PID]: sqlca: code: 0, state: 00000 51[NO_PID]: ecpg_get_data on line 49: RESULT: a offset: -1; array: no 52[NO_PID]: sqlca: code: 0, state: 00000 53[NO_PID]: ecpg_get_data on line 49: RESULT: 1.0 offset: -1; array: no 54[NO_PID]: sqlca: code: 0, state: 00000 55[NO_PID]: ecpg_get_data on line 49: RESULT: 2 offset: -1; array: no 56[NO_PID]: sqlca: code: 0, state: 00000 57[NO_PID]: ecpg_get_data on line 49: RESULT: a offset: -1; array: no 58[NO_PID]: sqlca: code: 0, state: 00000 59[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression 60[NO_PID]: sqlca: code: 0, state: 00000 61[NO_PID]: ecpg_execute on line 49: using PQexec 62[NO_PID]: sqlca: code: 0, state: 00000 63[NO_PID]: ecpg_process_output on line 49: correctly got 1 tuples with 5 fields 64[NO_PID]: sqlca: code: 0, state: 00000 65[NO_PID]: ecpg_get_data on line 49: RESULT: 2 offset: -1; array: no 66[NO_PID]: sqlca: code: 0, state: 00000 67[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no 68[NO_PID]: sqlca: code: 0, state: 00000 69[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no 70[NO_PID]: sqlca: code: 0, state: 00000 71[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no 72[NO_PID]: sqlca: code: 0, state: 00000 73[NO_PID]: ecpg_get_data on line 49: RESULT: offset: -1; array: no 74[NO_PID]: sqlca: code: 0, state: 00000 75[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression 76[NO_PID]: sqlca: code: 0, state: 00000 77[NO_PID]: ecpg_execute on line 49: using PQexec 78[NO_PID]: sqlca: code: 0, state: 00000 79[NO_PID]: ecpg_process_output on line 49: correctly got 1 tuples with 5 fields 80[NO_PID]: sqlca: code: 0, state: 00000 81[NO_PID]: ecpg_get_data on line 49: RESULT: 3 offset: -1; array: no 82[NO_PID]: sqlca: code: 0, state: 00000 83[NO_PID]: ecpg_get_data on line 49: RESULT: b offset: -1; array: no 84[NO_PID]: sqlca: code: 0, state: 00000 85[NO_PID]: ecpg_get_data on line 49: RESULT: 2.0 offset: -1; array: no 86[NO_PID]: sqlca: code: 0, state: 00000 87[NO_PID]: ecpg_get_data on line 49: RESULT: 3 offset: -1; array: no 88[NO_PID]: sqlca: code: 0, state: 00000 89[NO_PID]: ecpg_get_data on line 49: RESULT: b offset: -1; array: no 90[NO_PID]: sqlca: code: 0, state: 00000 91[NO_PID]: ecpg_execute on line 49: query: fetch mycur; with 0 parameter(s) on connection ecpg1_regression 92[NO_PID]: sqlca: code: 0, state: 00000 93[NO_PID]: ecpg_execute on line 49: using PQexec 94[NO_PID]: sqlca: code: 0, state: 00000 95[NO_PID]: ecpg_process_output on line 49: correctly got 0 tuples with 5 fields 96[NO_PID]: sqlca: code: 0, state: 00000 97[NO_PID]: raising sqlcode 100 on line 49: no data found on line 49 98[NO_PID]: sqlca: code: 100, state: 02000 99[NO_PID]: ecpg_execute on line 58: query: close mycur; with 0 parameter(s) on connection ecpg1_regression 100[NO_PID]: sqlca: code: 0, state: 00000 101[NO_PID]: ecpg_execute on line 58: using PQexec 102[NO_PID]: sqlca: code: 0, state: 00000 103[NO_PID]: ecpg_process_output on line 58: OK: CLOSE CURSOR 104[NO_PID]: sqlca: code: 0, state: 00000 105[NO_PID]: ecpg_execute on line 118: query: drop table a1; with 0 parameter(s) on connection ecpg1_regression 106[NO_PID]: sqlca: code: 0, state: 00000 107[NO_PID]: ecpg_execute on line 118: using PQexec 108[NO_PID]: sqlca: code: 0, state: 00000 109[NO_PID]: ecpg_process_output on line 118: OK: DROP TABLE 110[NO_PID]: sqlca: code: 0, state: 00000 111[NO_PID]: ECPGtrans on line 121: action "commit"; connection "ecpg1_regression" 112[NO_PID]: sqlca: code: 0, state: 00000 113[NO_PID]: ecpg_finish: connection ecpg1_regression closed 114[NO_PID]: sqlca: code: 0, state: 00000 115