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 66: query: set DateStyle to 'DMY'; with 0 parameter(s) on connection ecpg1_regression 6[NO_PID]: sqlca: code: 0, state: 00000 7[NO_PID]: ecpg_execute on line 66: using PQexec 8[NO_PID]: sqlca: code: 0, state: 00000 9[NO_PID]: ecpg_process_output on line 66: OK: SET 10[NO_PID]: sqlca: code: 0, state: 00000 11[NO_PID]: ecpg_execute on line 68: query: create table history ( customerid integer , timestamp timestamp without time zone , action_taken char ( 5 ) , narrative varchar ( 100 ) ); with 0 parameter(s) on connection ecpg1_regression 12[NO_PID]: sqlca: code: 0, state: 00000 13[NO_PID]: ecpg_execute on line 68: using PQexec 14[NO_PID]: sqlca: code: 0, state: 00000 15[NO_PID]: ecpg_process_output on line 68: OK: CREATE TABLE 16[NO_PID]: sqlca: code: 0, state: 00000 17[NO_PID]: ecpg_execute on line 71: query: insert into history ( customerid , timestamp , action_taken , narrative ) values ( 1 , '2003-05-07 13:28:34 CEST' , 'test' , 'test' ); with 0 parameter(s) on connection ecpg1_regression 18[NO_PID]: sqlca: code: 0, state: 00000 19[NO_PID]: ecpg_execute on line 71: using PQexec 20[NO_PID]: sqlca: code: 0, state: 00000 21[NO_PID]: ecpg_process_output on line 71: OK: INSERT 0 1 22[NO_PID]: sqlca: code: 0, state: 00000 23[NO_PID]: ecpg_execute on line 76: query: select max ( timestamp ) from history; with 0 parameter(s) on connection ecpg1_regression 24[NO_PID]: sqlca: code: 0, state: 00000 25[NO_PID]: ecpg_execute on line 76: using PQexec 26[NO_PID]: sqlca: code: 0, state: 00000 27[NO_PID]: ecpg_process_output on line 76: correctly got 1 tuples with 1 fields 28[NO_PID]: sqlca: code: 0, state: 00000 29[NO_PID]: ecpg_get_data on line 76: RESULT: Wed 07 May 13:28:34 2003 offset: -1; array: no 30[NO_PID]: sqlca: code: 0, state: 00000 31[NO_PID]: ecpg_execute on line 81: query: select customerid , timestamp from history where timestamp = $1 limit 1; with 1 parameter(s) on connection ecpg1_regression 32[NO_PID]: sqlca: code: 0, state: 00000 33[NO_PID]: ecpg_execute on line 81: using PQexecParams 34[NO_PID]: sqlca: code: 0, state: 00000 35[NO_PID]: ecpg_free_params on line 81: parameter 1 = 2003-05-07 13:28:34 36[NO_PID]: sqlca: code: 0, state: 00000 37[NO_PID]: ecpg_process_output on line 81: correctly got 1 tuples with 2 fields 38[NO_PID]: sqlca: code: 0, state: 00000 39[NO_PID]: ecpg_get_data on line 81: RESULT: 1 offset: -1; array: no 40[NO_PID]: sqlca: code: 0, state: 00000 41[NO_PID]: ecpg_get_data on line 81: RESULT: Wed 07 May 13:28:34 2003 offset: -1; array: no 42[NO_PID]: sqlca: code: 0, state: 00000 43[NO_PID]: ecpg_execute on line 95: query: insert into history ( customerid , timestamp , action_taken , narrative ) values ( $1 , $2 , 'test' , 'test' ); with 2 parameter(s) on connection ecpg1_regression 44[NO_PID]: sqlca: code: 0, state: 00000 45[NO_PID]: ecpg_execute on line 95: using PQexecParams 46[NO_PID]: sqlca: code: 0, state: 00000 47[NO_PID]: ecpg_free_params on line 95: parameter 1 = 2 48[NO_PID]: sqlca: code: 0, state: 00000 49[NO_PID]: ecpg_free_params on line 95: parameter 2 = 2003-05-08 15:53:39 50[NO_PID]: sqlca: code: 0, state: 00000 51[NO_PID]: ecpg_process_output on line 95: OK: INSERT 0 1 52[NO_PID]: sqlca: code: 0, state: 00000 53[NO_PID]: ECPGtrans on line 100: action "commit"; connection "ecpg1_regression" 54[NO_PID]: sqlca: code: 0, state: 00000 55[NO_PID]: ecpg_execute on line 102: query: drop table history; with 0 parameter(s) on connection ecpg1_regression 56[NO_PID]: sqlca: code: 0, state: 00000 57[NO_PID]: ecpg_execute on line 102: using PQexec 58[NO_PID]: sqlca: code: 0, state: 00000 59[NO_PID]: ecpg_process_output on line 102: OK: DROP TABLE 60[NO_PID]: sqlca: code: 0, state: 00000 61[NO_PID]: ECPGtrans on line 105: action "commit"; connection "ecpg1_regression" 62[NO_PID]: sqlca: code: 0, state: 00000 63[NO_PID]: ecpg_finish: connection ecpg1_regression closed 64[NO_PID]: sqlca: code: 0, state: 00000 65